Get cell address from Lookup function results

[Guest]

Hi Guis,

I have a spreadsheet to copy data into specific columns.

I was heading to use the lookup functions in order to identify de
destination cell address but I cannot convert the lookup results into a cell
reference.

Is there any way of doing that? Or else, how can I perform a search to
identify the correct destination cell address?

Thanks in advance
Felipe

 

[papou]

Hello Felipe
Use MATCH instead for example :

=MATCH(B1,A1:A500,0)
Where B1 is the criteria you're looking for
And A1:A500 is the range where stands your data.

This will return the position number where the value will be found.
It will then be easily adapted to return a cell address with the ADDRESS
function, for example:

=ADDRESS(MATCH(B1,A1:A500,0),1)
This will return an absolute range address
If you wish to return a relative cell address, use:
=ADDRESS(MATCH(B1,A1:A500,0),1,4)

See help on both these functions.

HTH
Cordially
Pascal