Use find with Index and Match
 

I have this formula:
INDEX([POlog.xls]POLOG!$O$5:O2003,MATCH($H5,[POlog.xls]POLOG!$P$5:$P2003,0)),
but I want to find the Match in Range(P5:X2003) not just (P5:P2003). In
other words, I want to find the match for H5 in multiple columns. Is it
possible, and if so, how? TIA

Greg

Use find with Index and Match
 

Try...

=INDEX([POlog.xls]POLOG!$O$5:$O$2003,MATCH(TRUE,MMULT(--([POlog.xls]POLOG
!$P$5:$X$2003=$H5),{1;1;1;1;1;1;1;1;1})0,0))

....confirmed with just ENTER, or

=INDEX([POlog.xls]POLOG!$O$5:O2003,MATCH(TRUE,MMULT(--([POlog.xls]POLOG!$
P$5:$X$2003=$H5),TRANSPOSE(COLUMN([POlog.xls]POLOG!$P$5:$X$2003)^0))0,0)
)

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article .com,
"GregR" wrote:

I have this formula:
INDEX([POlog.xls]POLOG!$O$5:O2003,MATCH($H5,[POlog.xls]POLOG!$P$5:$P2003,0)),
but I want to find the Match in Range(P5:X2003) not just (P5:P2003). In
other words, I want to find the match for H5 in multiple columns. Is it
possible, and if so, how? TIA

Greg

Use find with Index and Match
 

Domenic, unbelievable, I would have never figured it out. Thank you
very much.

Greg