Forum Discussion
Need a formula to output specific information
I have a set of data that is sorted horizontally by month and vertically by item. I am trying to create a formula that will look for a specific month and then output data from a specific cell base...
=INDEX($C$4:$I$15,MATCH($C$19,$B$4:$B$15,0),MATCH($C$18,$C$2:$I$2,0))
You can try this formula for the data layout of the example.
This worked well for me for what I needed. Thank you.