Match from Column and Row

Occasional Contributor

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.






2 Replies
best response confirmed by zackwilson11 (Occasional Contributor)



Is this what you are looking for?

index match.JPG 

It worked! Thank you so much!!!