Use formula to populate cells
 

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
Yournot Kim Paul 416.123.4567 905.123.4568
Whose Kim Sandy 604.123.4567 905.123.4569
Wheres Kim Antonie 780.123.4567 905.123.4570
Hi Kim Sheldon 403.123.4567 905.123.4571
By Kim Rose 205.123.4567 905.123.4572

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

Use formula to populate cells
 

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)

"BadRasta!" wrote:

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
Yournot Kim Paul 416.123.4567 905.123.4568
Whose Kim Sandy 604.123.4567 905.123.4569
Wheres Kim Antonie 780.123.4567 905.123.4570
Hi Kim Sheldon 403.123.4567 905.123.4571
By Kim Rose 205.123.4567 905.123.4572

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