VLookup

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

Ivor Williams

I'm using VLOOKUP to return values using the following
"=VLOOKUP(A3,M$3:N$7,2,FALSE)". When no match is found, #N/A is returned.

Is there a way to prevent #N/A from showing up? I'd like to do a sort on the
resulting list and can't do it when there are #N/A's in the column. In a
large list, it's far too much trouble to manually delete all the #N/A's.

Ivor
 
Ivor

=IF(ISNA(VLOOKUP(A3,M$3:N$7,2,FALSE)),"",VLOOKUP(A3,M$3:N$7,2,FALSE))

Regards

Trevor
 
Hi Ivor

One way would be to wrap it in an iserror statement
=IF(ISERROR(VLOOKUP(A3,M$3:N$7,2,FALSE)),""",VLOOKUP(A3,M$3:N$7,2,FALSE))
 
Back
Top