Results 1 to 3 of 3

Thread: Which function to use please

  1. #1
    Neophyte indi's Avatar
    Join Date
    Sep 2018
    Posts
    1
    Articles
    0
    Excel Version
    2016

    Which function to use please



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

    Hello. I am trying to link information from one sheet to a cell in another. I think I need a combination of LIST and MATCH but am unsure of syntax.

    I have attached a spreadsheet and need a formula in cell S2 of "Rider" worksheet to find the following:

    Match the information in column A of "Rider" worksheet with same information in column A of "Orders" worksheet and pick up the information in column L of "Orders" worksheet.

    Expected result for S2 of "Rider" is "XC Fence judge". Expected result for S3 is "Marshall"

    I've tried a few combinations but keep getting an error. I have hundreds of rows in my spreadsheet so really need to make it work.

    Thank you in advance
    Excel function help.xlsx

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    Perhaps?

    =INDEX(names,MATCH(A2,INDEX(names,0,1)),12)

    copied down


  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,616
    Articles
    0
    Excel Version
    365
    =VLOOKUP(A2,names,12,FALSE)
    ?

Posting Permissions

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