matthewlouis
Active Member
- Joined
- Mar 28, 2014
- Messages
- 374
- Office Version
- 365
- 2019
- Platform
- Windows
Hi All, trying to do nested Index and Match with IF statements . . . 6 nested IF's to be exact.
When I put =INDEX(IF(C8="Confirmed Sideways",'D1'!$Q$1:$Q$100),MATCH(F8,'D1'!$S$1:$S$100,0)), it works great, it returns what I need.
However, when I add the next IF statement:
=INDEX(IF(C8="Confirmed Sideways",'D1'!$Q$1:$Q$100),MATCH(F8,'D1'!$S$1:$S$100,0)), INDEX(IF(C8="Suspect Sideways",'D1'!$Q$1:$Q$100),MATCH(F8,'D1'!$S$1:$S$100,0))
I get #VALUE . I know it must have something to do with brackets, etc...
Can anyone see what I am doing wrong when I add the next IF statement?
Thanks in advance!
When I put =INDEX(IF(C8="Confirmed Sideways",'D1'!$Q$1:$Q$100),MATCH(F8,'D1'!$S$1:$S$100,0)), it works great, it returns what I need.
However, when I add the next IF statement:
=INDEX(IF(C8="Confirmed Sideways",'D1'!$Q$1:$Q$100),MATCH(F8,'D1'!$S$1:$S$100,0)), INDEX(IF(C8="Suspect Sideways",'D1'!$Q$1:$Q$100),MATCH(F8,'D1'!$S$1:$S$100,0))
I get #VALUE . I know it must have something to do with brackets, etc...
Can anyone see what I am doing wrong when I add the next IF statement?
Thanks in advance!