Need an interpretation

GaryDrummSr

New Member
Joined
May 10, 2019
Messages
13
=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?
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
=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?
 
Last edited:
Upvote 0
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
 
Upvote 0
Because the formulas do not return a real result, I suppose you can erase them. good luck
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top