using calculated address?

[jzemanek]

I have calculated an address using:
ADDRESS(MATCH(C188,C160:C184,0)-12,3,4)

This is equal to C9. How do I determine what's in the address?

Thanks, joeZ

 

[Frank Kabel]

Hi
=INDEX(C148:C184,MATCH(C188,C160:C184,0)-12)

 

[JBoulton]

Hi, jozey.

If your formula were in A1 and you wanted the contents of C9 to be displayed
in cell A2, you would put =INDIRECT(A1) in cell A2.

 

[Ron Rosenfeld]

I have calculated an address using:
ADDRESS(MATCH(C188,C160:C184,0)-12,3,4)

This is equal to C9. How do I determine what's in the address?

Thanks, joeZy

=INDIRECT(ADDRESS(MATCH(C188,C160:C184,0)-12,3,4))


--ron