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?

Hi!

Pivot tables! %^&*($!!!

Try this:

Entered as an array using the key combo of CTRL,SIFT,ENTER:

=INDEX(CN869:CN933,MATCH(TRUE,C0869:CO933<"",0))

Biff

"Space Elf" wrote in message
...
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?

Much Thanks!


"Biff" wrote:

Hi!

Pivot tables! %^&*($!!!

Try this:

Entered as an array using the key combo of CTRL,SIFT,ENTER:

=INDEX(CN869:CN933,MATCH(TRUE,C0869:CO933<"",0))

Biff

"Space Elf" wrote in message
...
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?