I think you should stick to Pecoflyer's solution. INDEX and MATCH are, contrary to INDIRECT, non-volatile and thus much better (and also easier to understand).



There are lots of ways to solve this, among many others =OFFSET(A$2,C2;;

Your formula =ADDRESS(MATCH(A2,A:A,0),COLUMN(A1)) could also have been =CELL("address",A2)
Pardon me, but I think your column B approach is an unnecessary complication.

By the way, shouldn't Pecoflyer's formula read: =INDEX(A:A,MATCH(A2,A:A,0)+C2)?


Edit: In the second line in the OFFSET formula there should be 3 commas and an ending parenthesis.

Xor, point taken. i understand.

But, just for closure, knowledge and the benefit of others like myself that may have searched for this thread, what would be the formula if i want to add to the cell address $A$2 and then display the results. bear in mind this was the initial intent of the thread.