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.
Thanks.
Please Login or Register to view this content.
Last edited by cherryt; 08-14-2013 at 04:18 AM.
maybe try it with or()
=IF(OR(ISBLANK(VLOOKUP($A$4,Sheet2!$F$4:$BD$2003,47,FALSE)),ISNA(VLOOKUP($A$4,Sheet2!$F$4:$BD$2003,47,FALSE))),"",VLOOKUP($A$4,Sheet2!$F$4:$BD$2003,47,FALSE))
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thank you VLady :D I've just figured that out and was about to close the thread! I'll still give you some rep :P
Nice to hear you've figured it out.
Thanks also.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks