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 usi...
=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($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!!!
