Vlookup

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

Hi

will you elobrate more

Krupesh

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

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

Try this:

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

Pete