Return Zero instead of N/A in V-Lookup

[gambils]

Tis the season for Christmas gift shopping and I'm trying to do a worksheet where I can do a lookup for items spent per person. It works fine when there is something listed for every person but, if nothing has been spent yet for a person, it returns "N/A." Is there someway I can alter the formula I'm using so that it returns a zero instead of N/A?

=vlookup(B19, $N2$2:$Q$132,2,false)

Thanks and Merry Christmas!

 

[Joe4]

Try:

[COLOR=#333333]=IFERROR(vlookup(B19, $N2$2:$Q$132,2,false),0)[/COLOR]

 

[gambils]

perfect- thank you very much

 

[Joe4]

You are welcome.