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

Adilson Soledade

Try this aproach:
B5 =VLOOKUP($B$4;Sheet3!$A$1:$E$7;5;FALSE)
B6 =VLOOKUP($B$4;Sheet3!$A$1:$E$7;3;FALSE)
B7 =VLOOKUP($B$4;Sheet3!$A$1:$E$7;4;FALSE)

PS: Sheet3!$A$1:$E$7 is the range where I suppose your data are distributed.
 
Top