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?

See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"abitanga" <(E-Mail Removed)> wrote in message
news:AD14E646-ABD9-488C-8A1D-(E-Mail Removed)...
> 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?

Hi,

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"abitanga" <(E-Mail Removed)> wrote in message
news:AD14E646-ABD9-488C-8A1D-(E-Mail Removed)...
> 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?