Vlookup IFNA

rtb2399

New Member
Joined
Dec 14, 2010
Messages
19
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
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

delaneyjm

Well-known Member
Joined
Apr 22, 2009
Messages
624
Without knowing more about your formula, try this construct:

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

Watch MrExcel Video

Forum statistics

Threads
1,112,812
Messages
5,542,634
Members
410,562
Latest member
FrankieBue
Top