obtain cell reference # from equation?

[Paradigm_Shift]

I want to reference a cell based on the result of a formula.

For example, I want to reference cell A(value returned from match formula), so that if the match formula result was 2, i could say =IF(A(MATCH(...)), [...] , [...]) and excel would read it as =IF(A2, [...] , [...]).

Thanks in advance for the help.

 

[jasonb75]

Try

=IF(INDEX(A:A,MATCH(...)),[..],[..])

 

[dave3009]

You want to read up on the OFFSET function.

 

[Paradigm_Shift]

Jason,

Worked! Thanks.