Excel VLOOKUP multiple values for each item
But problem here is each Name has multiple schools in sheet 1 and each Name has multiple sports in Sheet2 and my final sheet should have Name:School:Sport.
I need to vlookup with Name column.
Please review the screenshot for clear info. Kindly help me with this case.
Solved by X. E. in 26 mins