Microsoft Excel Using Match result

I have a drop down that I call match on. Can I directly incorporate matches result into a formula.

For example I am trying to say

=C(MATCH(J15,A1:A52,0))

I am using match to find the second component of the cells location. I am using Excel 开发者_StackOverflow2003.

---

=INDEX($C:$C,MATCH(J15,A1:A52,0))

---

=INDIRECT(ADDRESS(MATCH(I23,'State Sales Tax'!A2:A52,0)+1,3))