Vlookup IFNA

[rtb2399]

Hi, I am using Office 2007 and due to word differences in my Look Up Value I want to have a Vlookup that looks at one value and if it returns a #NA then I want the formula to look up a different a Different Lookup Value to find the correct result. Can anyone please show me how to do this in a formula fortmat? Thank you so much in advance! If you need anymore information please just let me know




-Taylor

 

[delaneyjm]

Without knowing more about your formula, try this construct:

=IF(ISNA(YOUR_FIRST_VLOOKUP(...)),
YOUR_SECOND_VLOOKUP(...),
YOUR_FIRST_VLOOKUP(...))

 

[barry houdini]

In Excel 2007 you can use IFERROR

=IFERROR(Vlookup1,IFERROR(Vlookup2,"No match"))