Ignore Blank and Zero in Lookup.

[Battledeck]

Hi.

I have a Lookup as per below but need to ignore any Zero's or Blanks from the 'Dock List Box' worksheet as they are currently coming up as #N/A in the cell that the lookup is returning answer.

=VLOOKUP(A6,'Dock List Boxes'!$A$3:$B$145,2,FALSE)

Thanks

[davesexcel]

Possibly,

=iferror(VLOOKUP(A6,'Dock List Boxes'!$A$3:$B$145,2,FALSE),"")