lookup cell location

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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
 
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)
 
Back
Top