1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VLOOKUP solution required please

Discussion in 'Ask an Excel Question' started by notremoh, Feb 13, 2019.

  1. notremoh

    notremoh New Member

    Messages:
    2
    I never made things very clear before, hope this does.
    I have an excel spreadsheet containing 3500 horses, their sire and racing form, called '19'
    upload_2019-2-13_16-43-10.png

    I would like to be able to insert the info of specific horses on to the sheet called 'races'
    upload_2019-2-13_16-49-57.png

    please help
    [​IMG]
    [​IMG]
  2. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    945
    Please have a read of the forum rules.
    - Don't repost but continue in the original one
    - Upload a sample file
    - Be specific on the problem you face and the wanted solution (with manual example)
    All to enable the helpers to help better
  3. bosco_yip

    bosco_yip Excel Ninja

    Messages:
    2,147
    The OP's original post has closed, please continue in this one.

    https://chandoo.org/forum/threads/vlookup-solution-required.40898/

    Regards
    Bosco
  4. eibi

    eibi Active Member

    Messages:
    272
    Per your subject line: Is VLOOKUP the only acceptable solution?

    How do you plan for the user to select the horses to pass through to the race table?

    I've assumed that you'll be adding a "selector" column to your source table; and I've also assumed that an array formula is acceptable.

    See attached.

    Attached Files:

Share This Page