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? |
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? |
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 08:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com