Thread: worksheet compatibility issues using VLOOKUP
View Single Post
 
Old 03-19-2016, 10:26 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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
File Type: xlsx DKSalaries_3.xlsx (34.9 KB, 10 views)
Reply With Quote