LinkBack URL
About LinkBacks
Or you can use this non array IF statement. Take your pick!
=IF(ISNA(MATCH(TRUE,INDEX(EXACT(D4,A2:A10),,1),0)),"",INDEX(B2:B10,MATCH(TRUE,INDEX(EXACT(D4,A2:A10),,1),0)))
Or you can use this non array IF statement. Take your pick!
=IF(ISNA(MATCH(TRUE,INDEX(EXACT(D4,A2:A10),,1),0)),"",INDEX(B2:B10,MATCH(TRUE,INDEX(EXACT(D4,A2:A10),,1),0)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks