Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 21099
  • Last Modified:

hello, how do I do an IFNA formula in Excel 2010

i am trying to fill in cell K2 by looking at A2, if A2 exists in a table on sheet 2 using Vlookup i want to use the Vlookup result.  If the Vlookup returns #n/a i want to use G2.  I have been looking into it and i believe i want is the IFNA formula that was introduced for 2013 but i need a way to do it in 2010.
0
garyrobbins
Asked:
garyrobbins
1 Solution
 
FamousMortimerCommented:
Hi, Please see attached workbook for a working example.  The formula should be like below...
=IF(ISNA(VLOOKUP(A2,Sheet2!A2:B9,2,FALSE)),G2,VLOOKUP(A2,Sheet2!A2:B9,2,FALSE))

Open in new window

Example.xlsx
0
 
Ejgil HedegaardCommented:
Use IFERROR when IFNA is not available

=IFERROR(VLOOKUP(A2,Sheet2!A2:B9,2,FALSE),G2)
1
 
FamousMortimerCommented:
^
0
 
garyrobbinsAuthor Commented:
Pleasingly simple and exactly what I needed, thank you
0
 
P Philippe DESGUINCommented:
Great!!!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now