I'm so close! I have a workbook that won't bring Vlookup results to the first sheet from additional sheets. I have figured out that if you copy and paste cell A1 sheet1 to A1 sheet 2, that solves the problem. However, copying and pasting 140+ names isn't practical.
The first sheet is downloaded from the internet as a .csv file, but the additional sheets are copied and pasted from another site. This seems to be causing some sort of format issues.

Attached Files

DKSalaries (7).xlsx (19.1 KB, 9 views)

Take a look here

Attached Files

DKSalaries_2.xlsx (32.3 KB, 10 views)

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, 8 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, 7 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, 7 views)

I really appreciate the help, you are a great person.