The formula below returns a 0 even if there is a blank in Scores!$E$3:$E$219, is there anyone who can amend the formula so that it returns a blank in the event of a blank in Scores!$E$3:$E$219 please?
=IF(ISNA(INDEX(Scores!$E$3:$E$219,MATCH(K3,Scores!$C$3:$C$219,0))),"",INDEX(Scores!$E$3:$E$219,MATCH(K3,Scores!$C$3:$C$219,0)))
Thank you
Kind regards
Pete
=IF(INDEX(Scores!$E$3:$E$219,MATCH(K3,Scores!$C$3:$C$219,0))=0,"",INDEX(Scores!$E$3:$E$219,MATCH(K3,Scores!$C$3:$C$219,0)))
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Are you using INDEX/MATCH to look up numbers or text?
BSB
Thank you that works! Much appreciated.
Hi, just numbers. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks