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!

    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

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,087
    Articles
    79
    Blog Entries
    14
    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 (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/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
  •