How to avoid #N/A

[pipemar]

Could somebody help me avoid #N/A error when using vlookup.

Thanks in advance,

 

[Scott Huish]

You didn't provide a formula, so I'll use the following as an example:

=VLOOKUP(B1,F:G,2,0)

The trick is to see if the value exists in your lookup table first:
=IF(ISNUMBER(MATCH(B1,F:F,0)),VLOOKUP(B1,F:G,2,0),"")

 

[jasonb75]

Or if you have excel 07

=IFERROR(VLOOKUP(B1,F:G,2,0),"")

(Used HOTPEPPER's example for you to compare)

 

[pipemar]

thanks problem solved.