Vlookup with Cell.address

Hello guys.

I am trying to make a vlookup formula referencing to a cell which is constantly changing place. I thought of using a variable which is the cell.address of this given cell. Therefore I am using the find function, and then I try to concatenate two variables on the vlookup - one of them is the cell.address.

What am I doing wrong?

Please Login or Register  to view this content.

Thanks in advance,
Joćo

Joćo

Without any arguments Address will return the address in A1 notation.

Can you post an example of the formula you want to use?

The cell.address is a string like "$A$1", that's not in R1C1 syntax. If you want to use the string, you'll need to switch to the non-R1C1 syntax for entering a formula.

Perhaps:

Please Login or Register  to view this content.