Use find with Index and Match

[GregR]

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 (P52003). In
other words, I want to find the match for H5 in multiple columns. Is it
possible, and if so, how? TIA

Greg

 

[Domenic]

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!

 

[GregR]

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

Greg