Adding criteria to this VLOOKUP

[thewiseguy]

hi all. Here is my current VLOOKUP:

=IFERROR(IFERROR(VLOOKUP(A2,BOM_Full,18,FALSE),VLOOKUP(A2,ProjectLevel_BOM,6,FALSE)),"")

I am trying to add another criteria to my 2nd VLOOKUP:

I'd like the 2nd vlookup to return a value ONLY if "Labor" is found in Project_Level_BOM, 3

Any help is greatly appreciated!

 

[DanteAmor]

Try:

=IFERROR(IFERROR(VLOOKUP(A2,BOM_Full,18,0),LET(a,ProjectLevel_BOM,INDEX(CHOOSECOLS(a,6),MATCH(1,(CHOOSECOLS(a,1)=A2)*(CHOOSECOLS(a,3)="Labor"),0)))),"")

 

[thewiseguy]

Try:

=IFERROR(IFERROR(VLOOKUP(A2,BOM_Full,18,0),LET(a,ProjectLevel_BOM,INDEX(CHOOSECOLS(a,6),MATCH(1,(CHOOSECOLS(a,1)=A2)*(CHOOSECOLS(a,3)="Labor"),0)))),"")

worked perfectly, thank you so much.