Thread: return opposite
View Single Post
  #1   Report Post  
Pat
 
Posts: n/a
Default return opposite

{=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))="",IN DEX(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