Hi
I am trying to use an ADDRESS formula as the first parameter in my VLOOKUP function (see below):
=VLOOKUP(ADDRESS(ROW(),COLUMN($S$30)),$S$9:$AI$26,COLUMN()-COLUMN($S$9)+1,0)
This doesn't seem to work. When I highlight this section and press F9, it shows me the following result: {"$S$33"}. This is the right reference - but I was surprised to see the curly brackets around it - am guessing that this is why it is not working.
Any ideas how to get around this?
Thanks
I am trying to use an ADDRESS formula as the first parameter in my VLOOKUP function (see below):
=VLOOKUP(ADDRESS(ROW(),COLUMN($S$30)),$S$9:$AI$26,COLUMN()-COLUMN($S$9)+1,0)
This doesn't seem to work. When I highlight this section and press F9, it shows me the following result: {"$S$33"}. This is the right reference - but I was surprised to see the curly brackets around it - am guessing that this is why it is not working.
Any ideas how to get around this?
Thanks