Excel 2007 : Problems with ISNA formula

[kearniesue]

Hi everyone,

This is probably a simple thing, but can someone tell me what is wrong with this formula?

=if(ISNA(VLOOKUP(B2,[SCHEDULE.xlsx]August!$O$81,10,FALSE),"",VLOOKUP(B2,[SCHEDULE.xlsx]August!$O$81,10,FALSE)))

It keeps highlighting the ,"", portion, but I can't seem to get to the bottom of the issue.

Thanks!

Karen

[protonLeah]

=IF(ISNA(VLOOKUP(B2,[SCHEDULE.xlsx]August!$O$81,10,FALSE)),"",VLOOKUP(B2,[SCHEDULE.xlsx]August!$O$81,10,FALSE))

[daddylonglegs]

Your lookup range appears to be a single cell - I don't think that will work.......but in general, in Excel 2007 you can use IFERROR, i.e.

=IFERROR(VLOOKUP(.....),"")

[kearniesue]

I know, I just figured that out, Daddylonglegs. Thank you so much for the help!

Now, if I could only figure out how to mark this as solved...