Excel formula help please?

[datahouse]

Hello,

I hope this is in the correct place sorry if not.

I am trying to create a spreadsheet to allow me to work out race results.

I need it to work as follows:

in heat 1 I type in cell b2 that a car came 1st ( i would like to type the postition number only. e.g. "1". Then it say 55 points and position 2 45 points etc etc.

I hope that makes sense

Thanks in advance

Gavin

[Ken Puls]

Hello, and welcome to the forum!

Not a worry. You need two things to do this:
1) A table that lists the position and points earned
2) A VLOOKUP formula to search out the correct points awarded

I've done up an example for you, and I've wrapped the VLOOKUP in an IF(ISERROR()) syntax. This is the route for Excel 2003 & prior to return 0 if no suitable match is found.

[datahouse]

Thankyou so much thats a great help