Automated input based on reference list

[bsw]

Hi. Im trying to do something pretty simple but can't seem to find it here because I'm not sure how to describe it.

I would like Excel to auto-fill the cells in column C to match the the numbers in column B from the matching reference list on the right hand side.

For example, when i type 6 into cell B5, it will reference the chart on the right and autofill the number 0 in cell C5 (because a 6 finish earns 0 points.) Cell B11 was a 3 finish, therefore it would log a value of 10.8 into cell C11 (because a 3 finish earns 10.8 points.)

I'm looking for a formula that I can copy into every cell down the C column for future additions to the chart.

Please help if you could and thank you in advance.

[Ron Coderre]

Using your posted example,
try this:

C5: =IF(COUNTIF($E$5:$E$13,B5),VLOOKUP(B5,$E$5:$F$13,2,0),"")

Copy that formula down as far as you need.

Does that help?

[bsw]

Ron,

I don't know how you were able to come up with that, but it worked just fine!

Thank you so much!