Dependent Data Validation Drop Down Lists in Multiple Columns

[Gorilla Munch]

Greetings,

I'm creating a spreadsheet for inputting sales data for a small sales booth. I researched and used the method from this site: http://www.contextures.com/xlDataVal02.html#video

It works great, except when I need to use a fourth dependent data drop-down. These are the first three cells headings and their data:

Product
=ProductList

Product Type
=INDIRECT(VLOOKUP(F9,ProductLookup,2,0)&"List")

Product Details
=INDIRECT(VLOOKUP(G10,INDIRECT(VLOOKUP(F10,ProductLookup,2,0)&"Lookup"),2,0)&"List")

Price
???? I can't get anything to work here. I would like it to look at the last three cells and give me a price based on the other criteria.

The reference data is on another sheet and setup so I can easily add or change things.

I've looked all over the web.

Thanks,

GM

 

[Gorilla Munch]

**SOLVED

This is the formula:

=INDIRECT(VLOOKUP(D9,INDIRECT(VLOOKUP(C9,INDIRECT(VLOOKUP(B9,ProductLookup,2,0) &"Lookup"),2,0)&"Lookup"),2,0)&"List")