Why do you think some of the numbers aren't coming to the first Sheet? This is confusing to me the Novice user.

Because the name is not found in Sheet2.
Henrik Stenson for example (Sheet1 cell E3) is not found in Sheet2. In Sheet2 there is something called Henrik Stenson titleist, but to Excel Henrik Stenson and Henrik Stenson titleist is not the same. Similarly for many others. The name in row 17, Byeong-Hun An is not found in Sheet2 etc.

Attached Files

DKSalaries_3.xlsx (34.9 KB, 10 views)

I removed all of the Titleist references from additional sheets 2-4. This isn't working either, if you can do this workbook for me I'll send you some $ if you give me an email address.
So on the first page I need the column B from sheets 2-4 for each corresponding player so they would have the price, and column B from each sheet that relates to their name.

Attached Files

PuertoRico.xlsx (27.5 KB, 9 views)

I have inserted 4 new sheets, Sheet1 (2), Sheet2 (2), Sheet3 (2) og Sheet4 (2). These sheets show the formulas I have used and they can be deleted if you so prefer.

In Sheet1 I have shown the final result.

Thank you for your offer to send some dollars but I am not here to earn money.

Attached Files

PuertoRico_2.xlsx (86.6 KB, 9 views)