Forum Discussion
Solved
Match from Column and Row
I'm working on creating a dashboard that will update to show me the true values. Before I get there, I'm working on adding the data and data sources. Since this involves multiple spreadsheets I'm using connections.
Where I'm stuck at is I have rows of "Org Codes" and columns that contains dates. I need a formula that will "match" based off a date and org code. Picture 1 is where I need the "pull" to be inserted, picture 2 is the data that is pulled from the sheets I or my team updates. So I need to compare the dates and org and return the value. Any help would be very much appreciated.
So far I used Index/Match to no avail.
=INDEX($B$14:$G$22,MATCH($A3,$A$14:$A$22,0),MATCH(REPLACE(B$2,3,1,"F"),$B$13:$G$13,0))Is this what you are looking for?
2 Replies
=INDEX($B$14:$G$22,MATCH($A3,$A$14:$A$22,0),MATCH(REPLACE(B$2,3,1,"F"),$B$13:$G$13,0))Is this what you are looking for?
- It worked! Thank you so much!!!
