Hi

I am trying to input the follwing formula however when using ISERR it will
only return the word FALSE. I am sure a couple of years ago I saw someone
use this function but they managed to return 0.00. Any ideas where I am
going wrong. I have tried substituting the FALSE for 0.00 but it does not
like it

=ISERR(VLOOKUP(B10,'Copy balance sheet'!A1:G400,7,FALSE))



Thanks
Julie