#N/A Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to duplicate a sheet with a formula but some of the cells have
this error message. =VLOOKUP(D107,ALLOCATION!$C$4:$D$131,2,FALSE).
I am not an expert in Excel need help. Using Excel 2003
 
#N/A is returned if Excel doesn't find an exact match when you use the FALSE
argument.

Do you think you should not be getting the error or just want to hide the #N/A?

Add the ISNA trap if you don't want to see the #N/A

=IF(ISNA(VLOOKUP(D107,ALLOCATION!$C$4:$D$131,2,FALSE)),"",VLOOKUP(D107,ALLOCATION!$C$4:$D$131,2,FALSE))


Gord Dibben MS Excel MVP
 
I have 115 rows of this formula it t is the last 8 rows that this error is
appearing.I should not be receiving this err
 
Upon second look at your formula, I don't understand what you're looking for.

Where is the formula entered?

Your lookup value cell D107 is part of your lookup table range.


Gord
 
You must log in or register to reply here.

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

Remove #N/A Error 3
EXCEL - IF(IFERROR(VLOOKUP question 0
Error message #N/A 3
Vlookup - N/A 4
#N/A 5
Please help on formula that will not work (If-And formula) 3
IF/VLOOKUP with #N/A results 6
#N/A Error 8

Back
Top