vlook up on multiple drop down lists

Ahmad920 

If you don't happen to have the most recent Excel release, if (in other words) that FILTER solution doesn't work, here's a solution that takes advantage of one of my favorite old-school functions that very few people know about...the various Database functions that begin with D_____. In this case DGET. It allows you to specify multiple criteria for retrieving a value from a talbe, exactly what you're trying to do. All you need to do to get it to work, is change the headings above the dropdowns where you specify the criteria so they match the column headings in Table1.

The formula is visible up there at the top of that image.

=IFERROR(DGET(B6:G19,"Cost",K7:M8),"No Match")

I've attached the revised file so you can experiment with other values to see how it works.

Ahmad920 

You say you prefer a VLOOKUP formula, but don't provide a reason.

May I recommend instead (if you have the most recent release of Excel) the FILTER function.

=FILTER(G7:G19,(C7:C19=K8)*(D7:D19=L8)*(E7:E19=M8),"No match")