+ Reply to Thread
Results 1 to 3 of 3

which better formula must i choise (lookup, index or offset) for point cellection?

  1. #1
    Registered User
    Join Date
    06-24-2015
    Location
    terengganu, malaysia
    MS-Off Ver
    2013
    Posts
    15

    which better formula must i choise (lookup, index or offset) for point cellection?

    hi,
    i have one problem to made formula can select point for table depend to time that runner get. If that runner's running fast, their get more point. Can you all help me to give better formula for me.
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: which better formula must i choise (lookup, index or offset) for point cellection?

    Hi

    With the time in say E2

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: which better formula must i choise (lookup, index or offset) for point cellection?

    change the column C into column A, and you can use Vlookup for that.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] offset index lookup
    By mattress58 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-01-2014, 02:50 PM
  2. Lookup offset index match or VBA
    By Blake 7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2014, 12:02 PM
  3. MATCH, LOOKUP, OFFSET, INDEX,...or what??
    By HuskerBronco in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-06-2006, 09:40 PM
  4. [SOLVED] Lookup, Index or Offset
    By reno in forum Excel General
    Replies: 1
    Last Post: 10-05-2005, 08:05 PM
  5. [SOLVED] lookup, index, match, offset, etc.
    By [email protected] in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-03-2005, 05:50 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1