Thread: 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))="",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

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!$BM$24:$BM$1000,0))="",
....

to be a blank ("") instead

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Pat" <glass_patrick@hotmail.com> wrote in message
news:41d6bd67$0$25601$ed2619ec@ptn-nntp-reader01.plus.net...
>
{=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
>
>

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 <at>yahoo<dot>com
----