Lookup to retrieve Cell address

[cidfidou]

Hi Excel Gurus,

Is there a way to retrieve the cell address using a lookup function? ie instead of retrieving the cell value I would like to retrieve the address of the cell..

Thanks in advance

 

[cidfidou]

Hey Guys,

I have a way to do what I wanted by using
INDIRECT("'" &$AG$1& "'!"&ADDRESS(MATCH($AK$9,$U$2:$U$3241,0),4,4,1))
thanks

 

[Aladin Akyurek]

Hi Excel Gurus,

Is there a way to retrieve the cell address using a lookup function? ie instead of retrieving the cell value I would like to retrieve the address of the cell..

Thanks in advance

What is de formula you have?

 

[cidfidou]

Hey Aladin,
not sure to undersatnd your question.. I was trying to find a formula that will convert my lookup into an address cell but I have found the above way around

 

[Aladin Akyurek]

Hey Aladin,
not sure to undersatnd your question.. I was trying to find a formula that will convert my lookup into an address cell but I have found the above way around

I wanted to know that lookup formula you have...

 

[cidfidou]

Hey Aladin,

I was trying to get the address of the cell and not the content of the cell using =LOOKUP(AK9,$U$2:$U$10,$B$2:$B$10)

 

[Aladin Akyurek]

Hey Aladin,

I was trying to get the address of the cell and not the content of the cell using =LOOKUP(AK9,$U$2:$U$10,$B$2:$B$10)

Thanks for providing the formula I asked for. I suppose $U$2:$U$10 is sorted in ascending order. That said, try:

=CELL("address",INDEX($B$2:$B$10,MATCH(AK9,$U$2:$U$10,1)))

 

[cidfidou]

Thanks Aladin... As usual, i am really pleased to receive great help from really smart people on Mr excel...

 

[Aladin Akyurek]

Thanks Aladin... As usual, i am really pleased to receive great help from really smart people on Mr excel...

You are welcome. Thanks for the kind feedback.

 

[cidfidou]

hey Aladin,

Is there a way to overcome the fact that your formula needs to have the data sorte