I can't figure out a way to get MATCH to use a lookup value that would be
anything except a blank cell inside a Pivot Table. I also tried OFFSET, but
the data I need to get to is to the left of the lookup column. Plus, I need
the row # for other functions.
=MATCH('anything but blank',CO869:CO933,0)
I have tried "0", 0, NOT("0"), NOT(0), NOT(ISERROR(CO869:CO933), ISBLANK
with previous, NOT(""), NOT(" ").
The column I'm searching has various numbers and I need to find the data to
the left of any number (nonblank).
Please help?