Glasgowsmile
Active Member
- Joined
- Apr 14, 2018
- Messages
- 280
- Office Version
- 365
- Platform
- Windows
Hello!
Trying to get an index match, or whatever formula I need to get a sheet to work.
Code currently pulls N/A.
I'm trying to match the Heading Title then subtitle and finally pull the data around it.
Here is the spreadsheet in case you need to reference it.
https://www.dropbox.com/s/ymsc2h5gty7xgmc/CodeExample.xlsx?dl=0
Trying to get an index match, or whatever formula I need to get a sheet to work.
Code currently pulls N/A.
I'm trying to match the Heading Title then subtitle and finally pull the data around it.
Code:
=INDEX(Data!C5:M40,MATCH(1,(Sheet1!E4=Data!C4:N4)*(Sheet1!A5=Data!A5:A31),0))
Here is the spreadsheet in case you need to reference it.
https://www.dropbox.com/s/ymsc2h5gty7xgmc/CodeExample.xlsx?dl=0