# Grid lists to Dropdowns

1. ## Grid lists to Dropdowns

Hello!

I currently use a simple grid in Excel to manually reference information to generate quotes. The main columns are:

Maximum Size (list of values from 50 to 1900 in increments of 50)
Category A Cost (list of values that relate to the values in Maximum Size Column)
Category B Cost (list of values that relate to the values in Maximum Size Column)
Category C Cost (list of values that relate to the values in Maximum Size Column)

What I am trying to do is set up in another sheet that pulls from the grid sheet with an option to use a dropdown to select the Maximum Size first and then another dropdown for the Category (A,B, or C) and have the appropriate value for the cost appear in the next column.

So if in the grid sheet 200 Max Size and Category A is 14, I would like the 14 to autopopulate after the two dropdowns are utilized.

I hope I'm explaining this clearly. I'm still learning different functions and formulas. Thanks in advance for your help!!!!

2. ## Re: Grid lists to Dropdowns

Hello,

with the data in Sheet1 starting in column A, like this ....

 A B C D 1 Max Size Cost A Cost B Cost C 2 50 1 11 111 3 100 2 12 112 4 150 3 13 113 5 200 4 14 114 6 250 5 15 115 7 300 6 16 116 8 350 7 17 117

.... you can have this scenario in Sheet2:

 A B C 1 Max size cost category cost 2 150 B 13

The formula in cell C2 is

=VLOOKUP(A2,Sheet1!A:D,MATCH(Sheet2!B2,{"0","A","B","C"},0),FALSE)

Is that something you can work with?

cheers, teylyn

3. ## Re: Grid lists to Dropdowns

Brilliant! Thank you! This works and I've already built everything out. !!!!!!

There are currently 1 users browsing this thread. (0 members and 1 guests)