VLookup

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
 
T

Trevor Shuttleworth

Ivor

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

Regards

Trevor
 
R

Roger Govier

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))
 
Top