I would like to find out if the formula I am using below is limited to eight
entries. I have names in column B (Mark, Matt, etc.) that have numbers
assigned to them in column A (1, 2, 3, etc.) and values in column C (5.5,
1.0, 2.6, etc.) When I type a number in column E (1, 2, 3, etc.) I would
like the value from column C to be inputted into column E. The formula works
below, however it is limited to eight entries and I have 40 in column B, A
and C. This maybe basic; however, I am somewhat new at this. I am using
Excel 2003

Please Help

=IF(E2=1,$C$2,IF(E2=2,$C$3,IF(E2=3,$C$4,IF(E2=4,$C $5,IF(E2=5,$C$6,IF(E2=6,$C$7,IF(E2=7,$C$8,IF(E2=8, $C$9,""))))))))

Try something like this:

=INDEX($C$2:$C$100,E2,1)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Mark R..." wrote:

I would like to find out if the formula I am using below is limited to eight
entries. I have names in column B (Mark, Matt, etc.) that have numbers
assigned to them in column A (1, 2, 3, etc.) and values in column C (5.5,
1.0, 2.6, etc.) When I type a number in column E (1, 2, 3, etc.) I would
like the value from column C to be inputted into column E. The formula works
below, however it is limited to eight entries and I have 40 in column B, A
and C. This maybe basic; however, I am somewhat new at this. I am using
Excel 2003

Please Help

=IF(E2=1,$C$2,IF(E2=2,$C$3,IF(E2=3,$C$4,IF(E2=4,$C $5,IF(E2=5,$C$6,IF(E2=6,$C$7,IF(E2=7,$C$8,IF(E2=8, $C$9,""))))))))

Thank you for you're help

Mark

"Ron Coderre" wrote:

Try something like this:

=INDEX($C$2:$C$100,E2,1)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Mark R..." wrote:

I would like to find out if the formula I am using below is limited to eight
entries. I have names in column B (Mark, Matt, etc.) that have numbers
assigned to them in column A (1, 2, 3, etc.) and values in column C (5.5,
1.0, 2.6, etc.) When I type a number in column E (1, 2, 3, etc.) I would
like the value from column C to be inputted into column E. The formula works
below, however it is limited to eight entries and I have 40 in column B, A
and C. This maybe basic; however, I am somewhat new at this. I am using
Excel 2003

Please Help

=IF(E2=1,$C$2,IF(E2=2,$C$3,IF(E2=3,$C$4,IF(E2=4,$C $5,IF(E2=5,$C$6,IF(E2=6,$C$7,IF(E2=7,$C$8,IF(E2=8, $C$9,""))))))))