auto populate different cells when selecting from drop down list.

[abitanga]

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?

 

[T. Valko]

See if this helps:

http://contextures.com/xlFunctions02.html

 

[Ashish Mathur]

Hi,

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com