index match help
For the INDEX argument, you need to specify a single column. I'm not clear
on whether you can search ranges of mixed sizes the way you have it in your
formula.
Try this example:
{=INDEX(PRX!A1:A111,MATCH(1,(PRX!A1:A111=Reference !J9)*(PRX!C1:C111=Reference!F5)*(PRX!A1:H1=Referen ce!H1),0))}
But it might fail because A1:H1 is not the same size as A1:A111.
HTH,
JP
"Kashyap" wrote in message
...
I tried with the below formula as well, but not resired result
=INDEX(PRX!A1:H111,MATCH(1,IF(PRX!A2:A111=Referenc e!J9,IF(PRX!C2:C111=Reference!F5,1)),0),MATCH(Refe rence!K6,PRX!A1:H1,0
))
Control+shift+enter
I need to index A:H
match J9 with A:A
match F5 with C:C
match H1 with A1:H1
|