LinkBack URL
About LinkBacks
=IF(ISNA(VLOOKUP(B2,[SCHEDULE.xlsx]August!$O$81,10,FALSE)),"",VLOOKUP(B2,[SCHEDULE.xlsx]August!$O$81,10,FALSE))
=IF(ISNA(VLOOKUP(B2,[SCHEDULE.xlsx]August!$O$81,10,FALSE)),"",VLOOKUP(B2,[SCHEDULE.xlsx]August!$O$81,10,FALSE))
Ben Van Johnson
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(.....),"")
Audere est facere
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...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks