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,(OtherSheetRan ge=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




"Tacklemom" wrote:

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 !