Index & Match (2 column criteria) multiple values

[Lars_C]

Hey there,

I have been reading around this subject for a while now and I can make it work for 1 value but not down a whole column.

Anyway, I am looking to have and index and match using 2 criteria in separate columns. But I created that, I could not drag it down my destination column (probably as it is an array).

"{=INDEX(C4:C98,MATCH(I4&J4, E4:E98&F4:F98, 0))}"

This equation lives in H4, but similar to the arrays, I would like to extend it to H98.

Anyone got an idea on where I go wrong and how to put me on the right track?

Thank you,
Lars

 

[Peter_SSs]

"{=INDEX(C$4:C$98,MATCH(I4&J4, E$4:E$98&F$4:F$98, 0))}"

Without seeing your data or an explanation of what you are trying to achieve, try the changes marked & then copy down.

 

[Aladin Akyurek]

Care to provide an input sample along with the appropriate output instead of discussing a (non-working) formula?

 

[Lars_C]

Hey both, thank you for your reply.

Peter_SSs it actually turned out that I put my "$" in the wrong positions by accident. Your suggestion works!

Aladin, I did try to explain it in the best way, without going into too much detail. I was convinced that my approach may be wrong, rather than detailed formula stuff. I was proven wrong

Thanks again,
Lars

 

[Peter_SSs]

Peter_SSs it actually turned out that I put my "$" in the wrong positions by accident. Your suggestion works!

Glad to help. Thanks for letting us know.