I've been beating this for a couple hours now. Actually, it's been beating me for a couple hours. My VLookup formula is okay, but I'm trying to get it to return a blank when the lookup cell is blank. At this point, my formula is as follows:
I would really appreciate any help I can get.=IF(ISBLANK(VLOOKUP($A$2,$A$81:$F$122,5,TRUE)),(VLOOKUP($A$2,$A$81:$F$122,5,TRUE)))
Thanks,
Dean
Bookmarks