formula for if and v look up for 2 values

[Tacklemom]

What I want is:
In Cell B2 you choose a size ( eg 1/2" ) from the drop down
In Cell C2 you choose a material either 304 or 316.

what I want is from B2 it will generate a vlook up for either 304 or 316
material depending on cell c2.... Not sure how to do this????

 

[Ken]

Donna ...

If you are using Filter Switches in Cols B & C ... & you Filter to a "size"
& "Material Type" what are you looking for a "vlookup" to do??? ... Thanks
.... Kha

 

[Tacklemom]

What it is... I have a worksheet linked for the V look up. But you need to
look up the size first ( A cells) then from there in (b) is the price for 304
material or in ( C) is the price for 316 material... But you need to know the
size ( from cell B2 on the main worksheet ) and the material ( from bell c2
on the main worksheet ) in order to generate which V look up you want to
use...

Thanks !

 

[Ken]

Donna ... (Hi)

You can't use a 2 value match for VLookup ... However, you may be able to
use INDEX & MATCH ... Something like:

=INDEX(OtherSheetPriceRange,match(1,(OtherSheetRange=B2)*(OtherSheetRange=C2),0))

Above assumes "Size" & "Material" are on one WorkSheet ... You are searching
for "Size" & "Material" on a 2nd WorkSheet & when found return the "Price".

HTH ... Kha