vlookup?

[secure]

In my document I have a drop down to select a system. (list). The next cell is contingent upon the first dropdown, and displays a list of part numbers and descriptions. This second cell also has a dropdown which I used table lables. Now in the 3rd cell I want to have the price of said part numbers be automatically filled in based on the table of the correct system. How do I do this?

 

[Smitty]

Welcome to the Board!

Check out this VLOOKUP tutorial:

http://www.contextures.com/xlFunctions02.html

Hope that helps,

 

[secure]

Thank you so much for responding so quickly. Unfortunatley, I've been at this for 3 days and my brain is mush. I think I have 3 situations that have to be completed before i can get a price.

Systemtype accesstable/price/labor cctvtable ...
access (part #)/price/labor (part #/price/labor)
cctv

 

[Smitty]

I completely understand the brain mush part after looking at a problem for too long.

Take a look at the link under my sig for :How to post a shot of your sheet on the Board.

 

[secure]

way toooooooooo complicated for me. all I get is an error 91, and don't have the patience to even try and follow the complicated directions.

sorry...

what else you got....

 

[ExcelNewb09]

Sounds like you're looking for something like this:
http://www.contextures.com/xlDataVal13.html

I'm not going to lie, its complicated to do what I think you're trying to do, but it is doable. Might want to brew another pot of joe before taking a swing at it.

Also, to do this, you will probably need to be comfortable with the NAMED RANGE and DYNAMICALLY NAMED RANGES.

http://www.ozgrid.com/Excel/DynamicRanges.htm
I had to have this bookmarked, and constantly refer back to it for ages before I could create these from writ.

Good Luck!

 

[Smitty]

all I get is an error 91

Check out the FAQ

It's not that hard, but it's totally worth the effort (minimal).

Now I need to go secure my existence by starting a fire for my wife before she gets home.

Post back when you get it figgered out.