SOLVED

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.

 

zackwilson11_0-1666719084810.png

zackwilson11_1-1666719164094.png

 

 

2 Replies
best response confirmed by zackwilson11 (Occasional Contributor)
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?

index match.JPG 

It worked! Thank you so much!!!