Use formula to populate cells

B

BadRasta!

Hello All,
I have a Workbook with 3 worksheets
Sheet1 called quote form
Sheet2 called Help
Sheet3 called Data

In Sheet1 I have the following information...
Cell A4 - To: B4 Imnot Kim
Cell A5 - E-mail: B5 "Populate"
Cell A6 - Phone: B6 "Populate"
Cell A7 - Fax: B7 "Populate"

in Sheet2 I have non related data to what I'm trying to accomplish

Sheet3 I have the following information...
Name Contact Tel Fax Email Address
Imnot Kim Ron 905.123.4567 905.123.4567 [email protected]
Yournot Kim Paul 416.123.4567 905.123.4568 [email protected]
Whose Kim Sandy 604.123.4567 905.123.4569 [email protected]
Wheres Kim Antonie 780.123.4567 905.123.4570 [email protected]
Hi Kim Sheldon 403.123.4567 905.123.4571 [email protected]
By Kim Rose 205.123.4567 905.123.4572 [email protected]

Here's my dilemma, when I type in Imnot Kim in cell B4 I would like Cell
B5-B7 to retrieve and populate the corresponding information from the data
sheet.

Once again Thnx,
Badrasta
 
A

akphidelt

Try This

Is B5

=Vlookup($B$4,Sheet3!$A$2:$E$6,6)

Make sure you change the 6 to the correct column that the Email is under.
Looks to me as 6, but it might be the 5th column.

B6

=Vlookup($B$4,Sheet3!$A$2:$E$6,4)

B7

=Vlookup($B$4,Sheet3!$A$2:$E$6,5)
 
Top