ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I obtain the address of a cell using the vlookup function? (https://www.excelbanter.com/excel-worksheet-functions/26337-how-do-i-obtain-address-cell-using-vlookup-function.html)

Spock May 16th 05 06:26 PM

How do I obtain the address of a cell using the vlookup function?
 
I'm trying to obtain the address of a cell using the Cell Function and the
Vlookup function. i.e. =Cell("address",vlookup(A2,A3:D20,4,False)) However, I
get an error when I execute the function. Any suggestions?

Mexage May 16th 05 06:32 PM

Why don't you try MATCH instead?

=MATCH(A2,A3:A20,0) will give you the row, relative to the range. For
example, if the value in A2 is in A5, the MATCH function will return 2-5=3.

Hope this helps and if it does please vote for this post.
G.Morales

"Spock" wrote:

I'm trying to obtain the address of a cell using the Cell Function and the
Vlookup function. i.e. =Cell("address",vlookup(A2,A3:D20,4,False)) However, I
get an error when I execute the function. Any suggestions?


Peo Sjoblom May 16th 05 06:35 PM

Not possible using VLOOKUP, try

=CELL("address",INDEX(A3:D20,MATCH(A2,A3:A20,0),4) )


Regards,

Peo Sjoblom


"Spock" wrote:

I'm trying to obtain the address of a cell using the Cell Function and the
Vlookup function. i.e. =Cell("address",vlookup(A2,A3:D20,4,False)) However, I
get an error when I execute the function. Any suggestions?



All times are GMT +1. The time now is 05:27 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com