{=IF(ISNA(MATCH(CC!$C102,PF05!$BM$24:$BM$1000,0)),"",IF(INDEX(PF05!BD$24:BD$
1000,MATCH(CC!$C102,PF05!$BM$24:$BM$1000,0))="",INDEX(PF05!$BE$24:$BE$1000,M
ATCH(CC!$C102,PF05!$BM$24:$BM$1000,0)),""))}
The above formula is doing the opposite of what I want it to do, a value
should only be returned if there is a corresponding value in the cell of BD
Thank you if you can help.
Pat
Bookmarks