Results 1 to 3 of 3

Thread: Excel formula help please?

  1. #1

    Excel formula help please?

    Register for a FREE account, and/
    or Log in to avoid these ads!


    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


  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Nanaimo, BC, Canada
    Blog Entries
    Excel Version
    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.
    Attached Files Attached Files
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: -||- Blog: -||- Forums:
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Thankyou so much thats a great help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts