Excel formula help please?

datahouse

New member
Joined
Jul 13, 2011
Messages
2
Reaction score
0
Points
0
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

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,520
Reaction score
5
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
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.
 

Attachments

  • xlgf273-1.xls
    23.5 KB · Views: 15
Top