LinkBack URL
About LinkBacks
How do I combine both function for one vlookup
=IF(ISBLANK(VLOOKUP(A2,S!$A$2:$G$50,7,FALSE)),"",VLOOKUP(A2,S!$A$2:$G$50,7,FALSE))
and
=IF(ISNA(VLOOKUP(A2,S!$A$2:$G$50,7,FALSE)),"",VLOOKUP(A2,S!$A$2:$G$50,7,FALSE))
How do I combine both function for one vlookup
=IF(ISBLANK(VLOOKUP(A2,S!$A$2:$G$50,7,FALSE)),"",VLOOKUP(A2,S!$A$2:$G$50,7,FALSE))
and
=IF(ISNA(VLOOKUP(A2,S!$A$2:$G$50,7,FALSE)),"",VLOOKUP(A2,S!$A$2:$G$50,7,FALSE))
Last edited by Jerseynjphillypa; 11-18-2011 at 04:46 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks