Match from Column and Row

[zackwilson11]

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 · Accepted solution]

@zackwilson11 

=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?

 

[#3]

It worked! Thank you so much!!!