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
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
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 Aladin... As usual, i am really pleased to receive great help from really smart people on Mr excel...