Preacherman771
New Member
- Joined
- Jun 15, 2021
- Messages
- 46
- Office Version
- 365
- Platform
- Windows
I have an INDEX formula which I entered in Q28 and then clicked on the + and dragged down to Q31. It works in the first cell but returns "n/a" in the rest of the column. I even manually entered the formula in each of the cells and still received the same result "n/a". Any help in understanding why this is occurring would be greatly appreciated.
Q28 =INDEX($M$56:$M$59,MATCH(1,(M28=$L$56:$L$59)*(R28=$L$56:$L$59),0)) Returned "R1L1a"
Q29 =INDEX($M$56:$M$59,MATCH(1,(M29=$L$56:$L$59)*(R29=$L$56:$L$59),0)) Returned "n/a"
Q30 =INDEX($M$56:$M$59,MATCH(1,(M30=$L$56:$L$59)*(R30=$L$56:$L$59),0)) Returned "n/a"
Q31 =INDEX($M$56:$M$59,MATCH(1,(M31=$L$56:$L$59)*(R31=$L$56:$L$59),0)) Returned "n/a"
M28 R1L0a N28 1 R28 1 L56 R1L0a M56 R1L1a
M29 R1L0b N29 2 R29 3 L57 R1L0b M57 R1L0b
M30 R1L0c N30 3 R30 2 L58 R1L0c M58 R1L0c
M31 R1L0d N31 4 R31 4 L59 R1L0d M59 R1L0d
Q28 =INDEX($M$56:$M$59,MATCH(1,(M28=$L$56:$L$59)*(R28=$L$56:$L$59),0)) Returned "R1L1a"
Q29 =INDEX($M$56:$M$59,MATCH(1,(M29=$L$56:$L$59)*(R29=$L$56:$L$59),0)) Returned "n/a"
Q30 =INDEX($M$56:$M$59,MATCH(1,(M30=$L$56:$L$59)*(R30=$L$56:$L$59),0)) Returned "n/a"
Q31 =INDEX($M$56:$M$59,MATCH(1,(M31=$L$56:$L$59)*(R31=$L$56:$L$59),0)) Returned "n/a"
M28 R1L0a N28 1 R28 1 L56 R1L0a M56 R1L1a
M29 R1L0b N29 2 R29 3 L57 R1L0b M57 R1L0b
M30 R1L0c N30 3 R30 2 L58 R1L0c M58 R1L0c
M31 R1L0d N31 4 R31 4 L59 R1L0d M59 R1L0d