EXCEL A1数值是如果是5 让A2=A5 ；A1数值是如果是6 让A2=A6 ；......

Question

EXCEL
A1数值是如果是5 让A2=A5
A1数值是如果是6 让A2=A6
A1数值是如果是7 让A2=A7
.............

A2这格公式怎么写

Answer 1

=INDIRECT("A"&A1)

Answer 2

A2=offset(A1,A1-1,0)