Eliminating #N/A

G

Guest

I have a formula that looks as follows:

=VLOOKUP(A70,'Staffing Assumptions'!$A$64:$D$75,4,FALSE)

There are some values in Column A that are not in the Table Array contained
in 'Staffing Assumptions'!$A$64:$D$$75. When this happens the formula
produces the #N/A.

In the event that the result of the VLOOKUP would be #N/A, I would rather
have the results be 0. Is there a way to modify the VLOOKUP formula to give
that result?
 
G

Guest

=IF(ISNA(VLOOKUP(A70,'Staffing
Assumptions'!$A$64:$D$75,4,FALSE)),0,VLOOKUP(A70,'Staffing
Assumptions'!$A$64:$D$75,4,FALSE))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I insert a dynamic reference of a range inside VLOOKUP? 4
Vlookups to return a N/A value 3
Vlookup and If statement help 1
VLOOKUP source values are a formula result. Getting #N/A 7
If (Vlookup >0) working, but what if Vlookup cell does not exist 18
Temp vaiables in formulas? 2
#N/A Error Reference 2
IF #N/A ( in a range), "ALERT","OK" 7

Top