software

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 gt;quot;0quot;, gt;0, NOT(quot;0quot;), NOT(0), NOT(ISERROR(CO869:CO933), ISBLANK
with previous, NOT(quot;quot;), NOT(quot; quot;).
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! %^amp;*($!!!

Try this:

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

=INDEX(CN869:CN933,MATCH(TRUE,C0869:CO933lt;gt;quot;quot;,0))

Biff

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

gt; Hi!
gt;
gt; Pivot tables! %^amp;*($!!!
gt;
gt; Try this:
gt;
gt; Entered as an array using the key combo of CTRL,SIFT,ENTER:
gt;
gt; =INDEX(CN869:CN933,MATCH(TRUE,C0869:CO933lt;gt;quot;quot;,0))
gt;
gt; Biff
gt;
gt; quot;Space Elfquot; gt; wrote in message
gt; ...
gt; gt;I can't figure out a way to get MATCH to use a lookup value that would be
gt; gt; anything except a blank cell inside a Pivot Table. I also tried OFFSET,
gt; gt; but
gt; gt; the data I need to get to is to the left of the lookup column. Plus, I
gt; gt; need
gt; gt; the row # for other functions.
gt; gt; =MATCH('anything but blank',CO869:CO933,0)
gt; gt; I have tried gt;quot;0quot;, gt;0, NOT(quot;0quot;), NOT(0), NOT(ISERROR(CO869:CO933), ISBLANK
gt; gt; with previous, NOT(quot;quot;), NOT(quot; quot;).
gt; gt; The column I'm searching has various numbers and I need to find the data
gt; gt; to
gt; gt; the left of any number (nonblank).
gt; gt; Please help?
gt; gt;
gt;
gt;
gt;