Hopefully there is an easy solution. I am working on a custom expense sheet.
I am trying to have a drop down menu of cost codes for the certain job
sites. I can create one list with all the info in the single cell, but I
would like to do is when you select the job side that is auto fills other
cells with the appropriate information from the drop down list.

ANy help appreciated..

VLOOKUP formula is one method.

Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based
on value, in your case, cost codes. Note the downloadable sample workbooks.

http://www.contextures.on.ca/xlFunctions02.html

Also see Debra's site for creating Data Validation dropdown menus for
choosing from a list.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 18:10:10 -0700, Tkawika
wrote:

Hopefully there is an easy solution. I am working on a custom expense sheet.
I am trying to have a drop down menu of cost codes for the certain job
sites. I can create one list with all the info in the single cell, but I
would like to do is when you select the job side that is auto fills other
cells with the appropriate information from the drop down list.

ANy help appreciated..