willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 893
- Office Version
- 365
- Platform
- Windows
I have this formula:
{=INDEX(CAPA!A:A,MATCH(1,(B17=CAPA!V:V)*(Dashboard!W1=CAPA!D:D),0))}
And what it does is it performs an index match with multiple criteria:
if the value in Column V (on sheet CAPA) matches B17 AND
if the value in column D (on sheet CAPA) matches W1 (on sheet Dashboard)
It will return the value in column AA (from sheet CAPA)
Now it will return the first match value, example: Blue 892
However I would like it to return ALL matches in Joint text: Blue 892, Green 596, Yellow 555 etc.
Is this possible?
Thank you to anyone who can help
Carla
{=INDEX(CAPA!A:A,MATCH(1,(B17=CAPA!V:V)*(Dashboard!W1=CAPA!D:D),0))}
And what it does is it performs an index match with multiple criteria:
if the value in Column V (on sheet CAPA) matches B17 AND
if the value in column D (on sheet CAPA) matches W1 (on sheet Dashboard)
It will return the value in column AA (from sheet CAPA)
Now it will return the first match value, example: Blue 892
However I would like it to return ALL matches in Joint text: Blue 892, Green 596, Yellow 555 etc.
Is this possible?
Thank you to anyone who can help
Carla