Hi,

Looks like you can use the VLOOKUP() or INDEX() and MATCH() function

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"abitanga" wrote in message
...
Help, can someone point me in the correct direction for this info! What I
am
trying to do is program a Excel spreadsheet to auto populate several
different cells when a user picks from a drop down list. So for example:
I
choose (January, 17 2002) and a seperate cell auto populates with the
(total
income generatred) and then another cell populates with the name of the
(person who generated the income). I have the data to create the list
just
don't know how to put it together or is this beyound me?