auto populate different cells when selecting from drop down list.
 

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?

auto populate different cells when selecting from drop down list.
 

See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"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?

auto populate different cells when selecting from drop down list.
 

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?