help with drop down lists!!

[Hygman]

I'm using excel 2007 and trying to use dropdown lists to fill in a table of data. I want it set so that when the item is chosen from the list the next two columns of the table are automatically completed with a unit price and a category code. This will make the data easier to handle later in the year.

I am a newcomer to the forum and I'm pretty inexperienced with Excel 2007.

Please go gentle on me!!

Phil

 

[Smitty]

Welcome to the Board!

You can use VLOOKUP for that. Here's a good tutorial: http://www.contextures.com/xlFunctions02.html

HTH,

 

[Hygman]

Thanks Smitty!!

Almost sorted!! When I do this it works fine but doesn't change the unit price every time only when my category changes. Any ideas?

 

[Joe Galvan]

Can you show and example of how your info is layed out and what type of data you are using?... is there criteria that you need to satisfy?

 

[Smitty]

Any ideas?

Not without seeing what you're using.

Check the link beneath my sig for how to post a shot of your sheet.

 

[Hygman]

Its ok guys!! I traced where my formulas were looking and I found the problem!! Simple answer is I had them looking at the wrong piece of info!!

All sorted and my worksheet is operating like a dream!!

THANKS!!!!