garyrobbins
asked on
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
^
ASKER
Pleasingly simple and exactly what I needed, thank you
Great!!!
Open in new window
Example.xlsx