Multi-level lookup based off dependent dropdowns

bc3mf

New Member
Joined
Sep 10, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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?
 

Attachments

  • Capture.PNG
    Capture.PNG
    33.1 KB · Views: 13

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
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.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,211
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top