Hello
I am having a problem getting an Index/Match combination to work. The formula is as follows:-
=INDEX(Data!$C$7:$AL$51,MATCH(Dashboard!$A14,Data!$A$5:$A$51,0),MATCH($C$4,Data!$C$6:$AL$6,0),MATCH($C$6,Data!$B$7:$B$27,0)-1)
Can anyone tell me what I am doing wrong please.
Thankyou.
Craig
I am having a problem getting an Index/Match combination to work. The formula is as follows:-
=INDEX(Data!$C$7:$AL$51,MATCH(Dashboard!$A14,Data!$A$5:$A$51,0),MATCH($C$4,Data!$C$6:$AL$6,0),MATCH($C$6,Data!$B$7:$B$27,0)-1)
- Data C7 to AL51 is a data set on another worksheet, my total range.
- Dashboard A14 is a text string reference that appears on my dashboard and also in the source data. The text string = "EOT Approvals %"
- Data A5 to A51 is a column of data where that text string might appear.
- C4 is a custom date field, MMM-YY in my Dashboard that i am trying to match to a range of dates in my source data sheet (C6 to AL6)
- C6 is a text string named in this case "sp71" that I am trying to match to a column of data in my source data sheet.
Can anyone tell me what I am doing wrong please.
Thankyou.
Craig
Last edited: