Is it possible to use both isblank and isna statement. I have a vlookup in which I want to use both and can't figure out where to use the AND statement. I've tried a few ways to merge but nothing seems to work!
Any ideas?
I want both to display nothing(the cell to be blank) if there is a error and nothing in the cell. Hope this makes sense.
=IF(ISBLANK(VLOOKUP($A$4,sheet2!$F$4:$BD$2003,47,FALSE)),"",VLOOKUP($A$4,sheet2!$F$4:$BD$2003,47,FALSE)
=IF(ISNA(VLOOKUP($A$4,sheet2!$F$4:$BD$2003,47,FALSE)),"",VLOOKUP($A$4,sheet2!$F$4:$BD$2003,47,FALSE)
Thanks.
Bookmarks