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

Try instead, array-entered*:

=IF(ISNA(MATCH(CC!$C102,PF05!$BM$24:$BM$1000,0))," ",IF(INDEX(PF05!BD$24:BD$1
000,MATCH(CC!$C102,PF05!$BM$24:$BM$1000,0))="","", INDEX(PF05!$BE$24:$BE$1000
,MATCH(CC!$C102,PF05!$BM$24:$BM$1000,0))))

*press CTRL+SHIFT+ENTER

Amended the VALUE_IF_TRUE return of this part:

... IF(INDEX(PF05!BD$24:BD$1000,MATCH(CC!$C102,PF05!$B M$24:$BM$1000,0))="",
....

to be a blank ("") instead

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Pat" wrote in message
...

{=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

Sorry, think the originally posted and the modified expression
need *not* be array-entered.

Just "normal" enter (i.e. press ENTER) will do
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----