lookup cell location

J

joe smith

Is there anyway to get the lookup function to output the cell's address of the value you are looking for? (ie I don't want to get the actual value of the cell, I want the address of the cell)
 
F

Frank Kabel

joe said:
Is there anyway to get the lookup function to output the cell's
address of the value you are looking for? (ie I don't want to get
the actual value of the cell, I want the address of the cell)
Click to expand...

Hi Joe
you can use the function ADDRESS. e.g. if you're looking for the value
in B1 in range A1:A1000 try
=ADDRESS(1,MATCH(B1,A1:A1000,0))

Frank
 
A

Aladin Akyurek

Posting your current lookup formula would simplify formulating possible
response.

joe smith said:
Is there anyway to get the lookup function to output the cell's address of
Click to expand...
the value you are looking for? (ie I don't want to get the actual value of
the cell, I want the address of the cell)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Newbie Help - IF Yes No Function 0
Word macro that can call cells out of Excel for a find and replace 0
Lookup Function help 1
Hlookup 0
IF AND Function Date Range Issues 6
Excel - Wich Function should I use? 1
Embedded lookup 3

Top