Lalalauren191
New Member
- Joined
- Mar 25, 2020
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
So maybe I need to use a different formula entirely, but here is my data first and then my question.
Hopefully this was enough information.
- Location is cell B2
- Month is cell B3
- Sheets that the data is being pulled from are:
- GSP D18
- GSP D35
- GSP D110
- GSP D121
- Index range on each sheet is B5:BQ17
- Match Range on each sheet for location names is A5:A17
- Match Range on each sheet for month is B3:BQ3
- My full current formula is: =INDEX('GSP D18'!$B$5:$BQ$17,MATCH($B$2,'GSP D18'!$A$5:$A$17,0),MATCH($B$3,'GSP D18'!$B$3:$BQ$3,0))
Hopefully this was enough information.