software

I'm trying to get the cell address, not the contents, of a cell referenced
using VLOOKUP. I've tried '=CELL(quot;addressquot;, VLOOKUP(5,Table,2,false)', but
I'm getting a formula error. EXCEL 2003. Thanks.

One way:

=CELL(quot;addressquot;,OFFSET(Table,MATCH(5,OFFSET(Table, ,,,1),FALSE)-1,1))

If you define Table to just be the first column of your table:

=CELL(quot;addressquot;,OFFSET(Table,MATCH(5,Table,FALSE)-1,1))VLOOKUP returns a value, not a range reference.

In article gt;,
quot;tfleischnyquot; gt; wrote:

gt; I'm trying to get the cell address, not the contents, of a cell referenced
gt; using VLOOKUP. I've tried '=CELL(quot;addressquot;, VLOOKUP(5,Table,2,false)', but
gt; I'm getting a formula error. EXCEL 2003. Thanks.

Another way

=CELL(quot;addressquot;,INDEX(Table,MATCH(7.5,INDEX(Table, ,1),0),2))--

Regards,

Peo Sjoblom

quot;JE McGimpseyquot; gt; wrote in message
...
gt; One way:
gt;
gt; =CELL(quot;addressquot;,OFFSET(Table,MATCH(5,OFFSET(Table, ,,,1),FALSE)-1,1))
gt;
gt; If you define Table to just be the first column of your table:
gt;
gt; =CELL(quot;addressquot;,OFFSET(Table,MATCH(5,Table,FALSE)-1,1))
gt;
gt;
gt; VLOOKUP returns a value, not a range reference.
gt;
gt; In article gt;,
gt; quot;tfleischnyquot; gt; wrote:
gt;
gt; gt; I'm trying to get the cell address, not the contents, of a cell
referenced
gt; gt; using VLOOKUP. I've tried '=CELL(quot;addressquot;, VLOOKUP(5,Table,2,false)',
but
gt; gt; I'm getting a formula error. EXCEL 2003. Thanks.
Oops! 7.5 should of course be 5

--

Regards,

Peo Sjoblom

quot;Peo Sjoblomquot; gt; wrote in message
...
gt; Another way
gt;
gt; =CELL(quot;addressquot;,INDEX(Table,MATCH(7.5,INDEX(Table, ,1),0),2))
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; quot;JE McGimpseyquot; gt; wrote in message
gt; ...
gt; gt; One way:
gt; gt;
gt; gt;
=CELL(quot;addressquot;,OFFSET(Table,MATCH(5,OFFSET(Table, ,,,1),FALSE)-1,1))
gt; gt;
gt; gt; If you define Table to just be the first column of your table:
gt; gt;
gt; gt; =CELL(quot;addressquot;,OFFSET(Table,MATCH(5,Table,FALSE)-1,1))
gt; gt;
gt; gt;
gt; gt; VLOOKUP returns a value, not a range reference.
gt; gt;
gt; gt; In article gt;,
gt; gt; quot;tfleischnyquot; gt; wrote:
gt; gt;
gt; gt; gt; I'm trying to get the cell address, not the contents, of a cell
gt; referenced
gt; gt; gt; using VLOOKUP. I've tried '=CELL(quot;addressquot;,
VLOOKUP(5,Table,2,false)',
gt; but
gt; gt; gt; I'm getting a formula error. EXCEL 2003. Thanks.
gt;
gt;
In article gt;,
quot;Peo Sjoblomquot; gt; wrote:

gt; Another way
gt;
gt; =CELL(quot;addressquot;,INDEX(Table,MATCH(7.5,INDEX(Table, ,1),0),2))

Well, OK, if you want to be *efficient* about it...lt;ggt;

Had OFFSET stuck in my head, obviously...Thanks for the correction!