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

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.


--
Adilson Soledade


"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