Help with a Nested VLOOKUP to add another condition

[diverbath]

How would I add a nested VLOOKUP to add another condition?

I would like to have the formula return a blank if the result of the VLOOKUP is "Hardware" or "Component"

Here is the current formula:

=IFERROR(IF(VLOOKUP(IF(ISNUMBER('Raw Data'!$G67+0),'Raw Data'!$G67+0,'Raw Data'!$G67),Product_List,5,0)="Hardware","",'Raw Data'!I67),"")

Right now the formula is working perfectly for the "Hardware" condition but I want to add "Component". Please help.

 

[Jonmo1]

Try

=IFERROR(IF(OR(VLOOKUP(IF(ISNUMBER('Raw Data'!$G67+0),'Raw Data'!$G67+0,'Raw Data'!$G67),Product_List,5,0)={"Hardware","Component"}),"",'Raw Data'!I67),"")

 

[diverbath]

Thanks so much Jonmo1!! That worked beautifully!!

 

[Jonmo1]

You're welcome.