willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 871
- Office Version
- 365
- Platform
- Windows
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
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