Locate the cell

Hi. I would like to achieve something in Excel and I would appreciate any help. Here is the scenario.
I have the following code:

MATCH(Q5,$A$2:$A$5000)+1

the above code gives me value of 522. I know that the value of Q5 is in cell A522. How do I make the result so it would show it as A522. Thank you in advance.

You can use the Address function.

The Syntax: ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

You already have the formula for row_num. if your data is always in column A then you would put 1 in the column_num. If it is larger than you can do a match across the column titles.

under the abs_num you would select on of the following:

1 or omitted Absolute
2 Absolute row; relative column
3 Relative row; absolute column
4 Relative

Thank you for your respond. Your formula worked. It did give me the location or the cell address. Now using this formula, is there a way I could get the value of cell A522? Thank you.

I think i got the formula for it. I just add a function called INDIRECT and it worked. Thank you for your time and help Pepe Le Mokko. I really appreciated it.