#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
 
Back
Top