Need an interpretation

[GaryDrummSr]

=INDEX($C$1:$C$16700,MATCH(1,INDEX(($B$1:$B$16700="A")*($B$1:$B$116700="B"),0),0))

On my spreadsheet, I had two columns, one for work shift, and one for what printing press was used.

Now both columns are filled with these formulas. I don't recall writing them.

I'm a little bit confused as well.

Can some one interpret them for me please?

 

[steve the fish]

Its an impossible formula. B1:B16700 cant equal both A and B.

 

[DanteAmor]

=INDEX($C$1:$C$16700,MATCH(1,INDEX(($B$1:$B$16700="A")*($B$1:$B$116700="B"),0),0))


($B$1:$B$16700="A")*($B$1:$B$16700="B")

I guess the number in red is a Typo error.
Your formula compares the contents of the cells $B$1:$B$16700 if it is equal to "A" and also checks if the same cell range is equal to "B".
Since it is not possible for a cell to have the value "A" and also the value "B", then it returns zero.

INDEX(0,0)
Since the result of the comparison is zero, then the result of Index is # N / A

MATCH(1,# N / A,0)
The next thing the formula does is Match 1 against the result of the coparation, Again the result is # N / A

INDEX($C$1:$C$16700,# N / A)
Finally try to get a value from column C according to the result, but as the result is # N / A, the final result is # N / A

Do you need to do something?

 

[GaryDrummSr]

DanteAmor,
Thank you for the explanation.
I still don't have any idea why this was placed in the spreadsheet, or who might have done it.
Maybe I'm loosing my mind.
I've had 3 such incidents in recent months, and I can't explain any of them.
Maybe a Saboteur.
Thanks again,
Gary

 

[DanteAmor]

Because the formulas do not return a real result, I suppose you can erase them. good luck

 

[GaryDrummSr]

Yes,
I will,
Thanks again

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.