hi i really need help!!! very confused

[ARNOLD]

does anyone know how to solve this problem of mine!!
I have a cell that has validation of the months and i have also have a
list of cells fulled with names of expenes, the colum next to it has
the amount of the expenses spent, i wanna know if you can change the
month from the validation( just like a dropdown combo box) which will
also change the information in the amount of expenses....
so i dont have to copy and paste all the months and expenses over and
over again.
and also in the process of doing this is possible to add the data in or
referance the cells highlighted in stead of having a long copied list
of info your already typed out!!
thanks to any replies!!



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
at http://www.ExcelTip.com/
------------------------------------------------

 

[Dave Peterson]

I'm on your side. I'm confused, too!

Maybe you're looking at using =vlookup().

If you have a table with the months in the left most column and info to the
right, you can use a formula like:

=vlookup(a1,sheet2!$a$1:$d$9999,3,false)

to get the the value from the adjacent columns.