how do I apply connectors?

[shrooms]

How do I apply connectors to the formulae?

Assuming I have
=MATCH(2,A2:A7,0) resulting in a value 4

I would like to use this formulae MATCH(2,A2:A7,0) to put into the formulae =CELL("contents",AMATCH(2,A2:A7,0))
to get the end result
=CELL("contents", A4) but it didnt work.

If it was other programme, i could simply use connectors like $+ that will result in the forumlae
=CELL("contents", [ A ] $+ [ MATCH(2,A2:A7,0) ] )
however, for excel im not sure what method should i use to achieve the same result...

admin teach me how do i go about achieving the same result using excel.. thanks

[NBVC]

Try:

=CELL("contents",INDIRECT("A"&MATCH(2,A2:A7,0)))

[shrooms]

thanks admin! it worked! :D