-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
can someone please tell me why this formula is not working?
- Thread starter sneakyla
- Start date
Alex Blakenburg
MrExcel MVP
- Joined
- Feb 23, 2021
- Messages
- 8,118
- Office Version
- 365
- Platform
- Windows
Your headings look like they are text while S2 looks to be a number.
What happens if you change the S2 part and add Trim to it ?
Oops you only need
Also I would have thought that was an array formula (CSE) are you really using O 2016 ?
What happens if you change the S2 part and add Trim to it ?
Excel Formula:
=MATCH(TRIM(S2),$C$1:$M$1,0)Oops you only need
Excel Formula:
(TRIM(S2)=$C$1:$M$1)Also I would have thought that was an array formula (CSE) are you really using O 2016 ?
Last edited:
Upvote
1
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,561
- Office Version
- 365
- Platform
- Windows
Along with what Alex has pointed out, I would have thought you need to have a match function for the column as well, like
Excel Formula:
=INDEX(C2:M32,MATCH(1,(Q2=A2:A32)*(R2=B2:B32),0),MATCH(S2&"",C1:M1,0))
Upvote
1
Solution
