You would normally use VLOOKUP to do this, but as you give no details
of your Sheet1 layout I can't give you a suggested solution.

Pete

On May 8, 11:29*pm, BadRasta!
wrote:
I have a list of contacts that I would like to display contact info from a
dropdown list
Cell A4 - To: * * *B4 (Drop down List) = Imnot Kim & the rest of the list
Cell A4 - E-mail: B4 "Populate"
Cell A4 - Phone: B4 "Populate"
Cell A4 - Fax: * * B4 "Populate"

This is what I got so far & it's not working (well it works for 1 name only)
=IF(B4="Imnot Kim",Sheet1!F2)
As soon as I drop to the next name i get "FALSE"

Please help
by the way I'm running WinXP & Excel 2003

Thnx,
BadRasta