Solved

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

Posted on 2014-07-18
5
12,966 Views
Last Modified: 2016-09-12
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
Comment
Question by:garyrobbins
5 Comments
 
LVL 10

Expert Comment

by:FamousMortimer
ID: 40204759
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
 
LVL 21

Accepted Solution

by:
Ejgil Hedegaard earned 500 total points
ID: 40204767
Use IFERROR when IFNA is not available

=IFERROR(VLOOKUP(A2,Sheet2!A2:B9,2,FALSE),G2)
1
 
LVL 10

Expert Comment

by:FamousMortimer
ID: 40204771
^
0
 

Author Closing Comment

by:garyrobbins
ID: 40204856
Pleasingly simple and exactly what I needed, thank you
0
 

Expert Comment

by:P Philippe DESGUIN
ID: 41794363
Great!!!
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now