To many Ifs

[Abazaba]

I am trying to make an If Statement but I think its too long.
Lets say
A2:A22 is a list of name
J3 returns a number between 1 - 20
If J3=1 then A1=A2
If J3=2 then A1=A3
If J3=3 the A1=A4
and so on. But I can't make an IF statement that looks for all 20. Any suggestions?

This is my IF statement at the moment.
=IF(J3=1,A3,IF(J3=2,A4,IF(J3=3,A5,IF(J3=4,A6,IF(J3=5,A7,IF(J3=6,A8,IF(J3=6,A9,IF(J3=7,A9,))))))))

Thanks for any help

[duane]

=OFFSET(A1,J3,0,1,1)

in cell a1

[richardreye]

Try using the INDEX function.

=INDEX(A2:A22,J3)

Cheers!

[Abazaba]

I tried Duane's offset and it was returning the name 1 below the right name.

so I tried the index fuction and it seems to be working right. Thanks so much!
This is makeing my job easier!

[duane]

glad you got the right answer but your post was misleading

If J3=1 then A1=A2
If J3=2 then A1=A3
If J3=3 the A1=A4
and so on. But I can't make an IF statement that looks for all 20. Any suggestions?

This is my IF statement at the moment.
=IF(J3=1,A3,IF(J3=2,A4,IF(J3=3,A5,IF(J3=4,A6,IF(J3 =5,A7,IF(J3=6,A8,IF(J3=6,A9,IF(J3=7,A9,))))))))