Hi,

Are you trying to do this

=IF(ISNA(VLOOKUP(B10,'Copy Balance
Sheet'!A1:G400,7,FALSE)),"",VLOOKUP(B10,'Copy Balance Sheet'!A1:G400,7,FALSE))

Mike

"Jools" wrote:

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