Stuck with an =IF

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 value’s 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 value’s 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 value’s 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,""))))))))