Multiple Vlookups in If then statement

[uamdb1978]

I need to pull information from the Description column from a row of data. People will be searching using either a "Part number" or an "Internal Part Number". I want the if then to perform a Vlookup looking for the part number. If the part number is valid give the Description. If the Part number is invalid to perform a Vlookup using the Internal part number.

I have the formula written but I cannot figure out what to use in the if then for the value not found (#N/A). Any suggestions? Below is the formula and the table.

Thanks in advance

David

=IF(VLOOKUP(A15,F5:H10,2,FALSE)="#n/a",VLOOKUP(A15,F5:H10,3,FALSE),VLOOKUP(A15,F5:H10,3,FALSE))

PartID	Internal ID	Description
1​	a	Test
2​	b	Test1
3​	c	Test2
4​	d	Test3
5​	e	Test4

 

[jasonb75]

Try

=IFERROR(IFERROR(VLOOKUP(A15,$G$5:$H$10,2,FALSE),VLOOKUP(A15,$F$5:$H$10,3,FALSE)),"No Match")

 

[VBE313]

Assuming A15 is where you enter the "Part ID" or "Internal ID"....

=IFNA(IFNA(VLOOKUP(A15,$F$5:$H$10,3,FALSE),VLOOKUP(A15,$G$5:$H$10,2,FALSE)),"None")

 

[uamdb1978]

Thanks guys. I will try both.