=if(isna(vlookup formula),0,vlookup formula)

"Stuart" wrote:

hi

im playing with a spreadsheet at the moment trying to use vlookup which i
have working

however, instead of when the vlookup value providing a value of n/a when
false, is there a way that i can use an if statement to return a value of "0"
(zero)

thanks

stuart