[SOLVED] Vlookup from a dependent drop down list

**dmbalzer** · 03-08-2011, 06:13 PM

Hi everyone,

I am trying to create a spreadsheet where I select a part size, then select a vendor for the specified part size, and then have a price automatically added to the sheet.
So far I have been able to the first data validation drop down where you select the size, then a dependent data validation drop down where you select vendor. I need help populating a cell with the price based on the selected vendor. I have searched and searched and I can VLOOKUP a price based on the selected size, but not the selected vendor i am guessing due to its dependencies. Any Help would be greatly Appreciated. I have attached the workbook that I have been using thus far.
Thanks,
-David

**Blake 7** · 03-08-2011, 06:28 PM

In k5

=SUMPRODUCT(($A$1:$A$7=I2)*($B$1:$B$7=J2),$C$1:$C$7)

or

=INDEX(C1:C7,MATCH(1,(B1:B7=J2)*(A1:A7=I2),0)) confirmed with CSE

**dmbalzer** · 03-08-2011, 07:42 PM

Awesome! Thanks for the help!

**Palmetto** · 03-08-2011, 09:35 PM

Cross posted at Ozgrid

**marcelkahn5** · 06-25-2015, 02:46 PM

Hi,

I'm having similar trouble.

I am trying to create a drop down list of Regions that when selected will limit the results of my Machine Size Column so that when the Machine SIze is selected, it shoots out a Price.

Attached is a sample file! Any help would be LIFE SAVING!