VLOOKUP solution required please

[notremoh]

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'


I would like to be able to insert the info of specific horses on to the sheet called 'races'


please help

 

[GraH - Guido]

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

 

[bosco_yip]

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

The OP's original post has closed, please continue in this one.

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

Regards
Bosco

 

[eibi]

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.