RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 810
- Office Version
- 365
- Platform
- Windows
It's Friday Evening and my brain is melted, I can't think and this is providing me with errors which is incredibly frustrating.
{=INDEX(Dashboard!$D$4:$D$17143,MATCH(1,INDEX((LARGE(IF(Dashboard!$A$4:$A$17143=A3,Dashboard!$O$4:$O$17143),G3)=Dashboard!$O$4:$O$17143)*(Dashboard!$A$4:$A$17143=A3),),0))}
That's my formula, I need to add one more criteria.
Dashboard is where all the data is held. Column D is a list of Tour References which I am dragging back when it finds the highest score in Column O, this finds the highest score based on a range of cells 17,143 long which is column A.
So the current criteria is "If I can find A3 in Dashboard A4:A17143" and "Find the highest score" and return it.
I need to add another criteria which is "If in Dashboard 'column I' find D3"
When I do this, I get an error:
{=INDEX(Dashboard!$D$4:$D$17143,MATCH(1,INDEX((LARGE(IF(Dashboard!$A$4:$A$17143=A3,Dashboard!$O$4:$O$17143),G3)=Dashboard!$O$4:$O$17143)*(Dashboard!$A$4:$A$17143=A3)*(Dashboard!$I4:I$17143=D3),),0))}
Hope someone can help before what remains of my consciousness vapourises.
{=INDEX(Dashboard!$D$4:$D$17143,MATCH(1,INDEX((LARGE(IF(Dashboard!$A$4:$A$17143=A3,Dashboard!$O$4:$O$17143),G3)=Dashboard!$O$4:$O$17143)*(Dashboard!$A$4:$A$17143=A3),),0))}
That's my formula, I need to add one more criteria.
Dashboard is where all the data is held. Column D is a list of Tour References which I am dragging back when it finds the highest score in Column O, this finds the highest score based on a range of cells 17,143 long which is column A.
So the current criteria is "If I can find A3 in Dashboard A4:A17143" and "Find the highest score" and return it.
I need to add another criteria which is "If in Dashboard 'column I' find D3"
When I do this, I get an error:
{=INDEX(Dashboard!$D$4:$D$17143,MATCH(1,INDEX((LARGE(IF(Dashboard!$A$4:$A$17143=A3,Dashboard!$O$4:$O$17143),G3)=Dashboard!$O$4:$O$17143)*(Dashboard!$A$4:$A$17143=A3)*(Dashboard!$I4:I$17143=D3),),0))}
Hope someone can help before what remains of my consciousness vapourises.