3 criteria vlookup

[Leif Magnus]

Ive attached a workbook.
This is what Im looking for:
Write to column F on first sheet. If column H says Fibrex then match column I on sheet one with column B on sheet 2. once it has found the right row, lookup what is in column L of sheet two. if no Fibrex then leave blank.

Basically matching diameters then retrieving the info in column L.
TEST.xlsx

Thank you

[Leif Magnus]

Are my instructions unclear? Any feedback would be appreciated

[davidandrew23]

=IF(H3="FIBREX",VLOOKUP(I3,Sheet2!B:L,11,0),"")

Try this...I think if I understand what you are looking for.

[FDibbins]

in I3, copied down, use this...

=IF(H3="Fibrex",IFERROR(VLOOKUP(I3,Sheet2!$B$1:$L$13,11,FALSE),""),"")

your original formula was looking in another file (on a network, from the looks of it?)...
=IF(H3="fibrex",VLOOKUP(I3,'N:\Jobs\4230 - Oxy - Iris - Mustang Eng\07. Reference Files\[4230 Master Parts AB.xlsx]Master Parts List'!$D$176:$N$188,11,0),"")
if you need to reference that file instead of your table on sheet2, use...
=IF(H3="fibrex",iferror(VLOOKUP(I3,'N:\Jobs\4230 - Oxy - Iris - Mustang Eng\07. Reference Files\[4230 Master Parts AB.xlsx]Master Parts List'!$D$176:$N$188,11,0),""),"")

[Leif Magnus]

Thanks FDibben. forgot about the iferror(..