Index Match formula with 2 matches

[willow1985]

Hello,

I was wondering if someone could help me with a formula.

I frequently use the following Index Match formula:

=INDEX(P:P,MATCH(C2,O:O,FALSE))

if C2 matches a value in column O it will return the corresponding value in P.

What I would like to do is have 2 matches.

return the value in P if C2 matches the value in O AND if I2 matches the value in column Q,

aka =INDEX(P:P,MATCH(C2,O:O,FALSE) AND MATCH(I2,Q:Q,FALSE)

Is there a way to do this?

Thank you to anyone who can help

Carla

 

[Fluff]

Guys, you can now use the formula XLOOKUP in the latest office 365. Easier and nicer than Index Match as it also has more options... please look at it

I'm fully aware of the new functions, but as the OP does not have them, I felt it would be pretty pointless suggesting she use them.

 

[willow1985]

Yes that's right.

Thank you very much

 

[Fluff]

My pleasure.