I need a formula

[ldh]

hi, please help.

A1's value is "red"
A2's value is "green"

how to achieve this:

When I input "1" in A3,
A4 appear A1's value,

When I input "2" in A3,
A4 appear A2's value

thanks!

 

[Arvi Laanemets]

Hi

=INDIRECT("A" & A3)
or
=OFFSET(A1,A3-1,0)


Arvi Laanemets

 

[Hank Scorpio]

Hi

=INDIRECT("A" & A3)
or
=OFFSET(A1,A3-1,0)

Or

=IF(A3=1,A1,IF(A3=2,A2,"Invalid Selection"))