Need vlookup to show blank, or 0 instead of n/a 2

[netrusher]

Below is the formula for a vlookup. It is working ok.
My question is: How can I get the column that shows
the points to be blank or zero instead of #n/a?

=VLOOKUP(C4,POINTS,2,FALSE)

 

[macropod]

Hi netrusher,

One way:
=IF(ISERROR(VLOOKUP(C4,POINTS,2,FALSE)),0,VLOOKUP(C4,POINTS,2,FALSE))

Cheers

[MS MVP - Word]

 

[AnotherHiggins]

FYI: You can also use ISNA, which checks specifically for the #N/A error. ISERROR looks for any error. But either works fine in your case.

Bit I've read that COUNTIF is faster than VLOOKUP. So it would be better to do something like:
[tab][COLOR=blue white]=If(Countif(POINTS, C4),VLOOKUP(C4, POINTS, 2, 0), "")[/color]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.