Posted to microsoft.public.excel.worksheet.functions

tfleischny

Posts: n/a

How do I get the cell address of a VLOOKUP reference?

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do I format a cell reference to move as source changes	KGray	Excel Worksheet Functions	1	August 13th 05 12:41 AM
Using a cell reference of a sheet in Vlookup	crazybass2	Excel Worksheet Functions	3	August 12th 05 07:51 PM
Possible Lookup Table	Karen	Excel Worksheet Functions	5	June 8th 05 09:43 PM
How do I find the contents of a cell using the "ADDRESS" function.	sweeney	Excel Worksheet Functions	2	April 5th 05 03:23 AM
name of another worksheet in cell for reference	Tom A Johnson	Excel Worksheet Functions	2	November 11th 04 11:28 PM

All times are GMT +1. The time now is 02:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us