#INVALID VALUE from =INDEX formula

JLuke

I have this formula, that works in other sheets that I have, however in this one it returns the #INVALID VALUE error. Help?

=INDEX([Current Task]3:[Weekly Status Notes]86, MATCH(true, [Current Task]3:[Current Task]86, 22)

Paul Newcome

Your 22 is in the MATCH function. That part of the MATCH function can only handle 1, 0, or -1. Try this for the ending instead:

…………………………………. [Current Task]86, 0), 22)

Paul Newcome

Your 22 is in the MATCH function. That part of the MATCH function can only handle 1, 0, or -1. Try this for the ending instead:

…………………………………. [Current Task]86, 0), 22)

JLuke

Got it fixed, thanks!

Paul Newcome

Happy to help. 👍️