Vlookup

[John Eakins]

When I do a VLOOKUP I want a zero in the column if the VLookup is not
successful
What function do I use?

 

[krupesh]

Hi

will you elobrate more

Krupesh

 

[John Eakins]

In some cases when I do a Vlookup there is no matching entry found s
the formula returns #N/A

If this happens I want to place a zero in the cell as opposed to seein
the #N/A messag

 

[Pete_UK]

Try this:

=IF(ISNA(Vlookup_formula),0,Vlookup_formula)

Pete