Conditions

[Lahi]

First sorry for my English.
May I know how to create a conditional function for this reason.

I create a function in A1 cell using data validation function list option.
After that I can select in A1 cell as 2000, 2001, 2002, 2003 like that.

I typed in I column as I3=1 , I4=2 , I5=3

Now I want to prepare a condition in A3 cell If A3=2000 A3 = I3 and
If A3=2001 A3 = I4 and If A3=2002 A3 = I4 and If A3=2003 A3 = I5 like that.

Please help me to create this condition.

 

[Mike H]

Hi,

Maybe this

=CHOOSE(A1-1999,I3,I4,I5)

Mike

 

[Lahi]

Thank you very much for your kind help. I found this method. I used If
condition.
=IF($A$1=2009,I3,IF($A$1=2010,J3,IF($A$1=2011,K3,IF($A$1=2012,L3)))) like
that.