Multi-level lookup based off dependent dropdowns

[bc3mf]

New to the forum so sorry if this is in the wrong spot! Sample workbook has been added to attachments.

It is exhausting constantly looking through price books so was wanting to generate an easier way to lookup prices based on drop down (data validation) criteria.

Drastically reduced the size for this example, total sheet is >8000 cells deep. Also the descriptions need to be cleaned up but not focused on that right now.

Ideally I'd like to have the first dropdown list:
BLKPIPE
FITTINGS - BRASS
FITTINGS - STAINLESS

If "BLKPIPE" is selected in the first then I'd like it to generate the below in the next drop down:
PIPE
BUSHING
FLANGES

If "PIPE" is selected then the next dropdown will populate:
1/2" PIPE
3/4 PIPE
1 1/2 x 2
2 x 8

If "1/2" pipe is selected then generate price of .77 I'll then take that cell to an estimate page and generate a total price based on "qty" or Length"

I've done a lookup before with combos of "if, match, offset" statements but the sheer size of this thing is daunting. May even be in a VBA range which I'm not too familiar with.

For the most part it is a 3 description path to get to the price but a few oddballs have 4 and a single one has 5.

Any easy way to do this?

 

[Akuini]

Hi, @bc3mf
Welcome to the Forum
You need to setup 4 level dependent data validation.

Could you post your example as table not image?
Please use XL2BB tool
OR
just copy your table and paste it here.
OR
Could you upload a sample workbook (without sensitive data) to a sharing site like dropbox.com or google drive?
And then share the link here.
This will make it easier to test & find a solution.

 

[Wes]

Curious how this turned out?