I have a worksheet that has a column of names in it. I'm trying to VLOOKUP to another sheet, column A, and returning the value in Column B if it finds the lookup.
All columns are text columns with names.
When I use the 'true' option in the vlookup, the results are about 50% accurate, and if I use 'false'then it's only about 5% accurate. The problem is that the spelling varies between the two columns. Is there an accurate way to do this?
Say on sheet1 in column B I have the vlookup:
=(C1,'sheet'!A1:B800,2,false) or
=(C1,'sheet'!A1:B800,2,true)
Can you vlookup with a partial string? I have about 17000 lines that I need to populate with this.
All columns are text columns with names.
When I use the 'true' option in the vlookup, the results are about 50% accurate, and if I use 'false'then it's only about 5% accurate. The problem is that the spelling varies between the two columns. Is there an accurate way to do this?
Say on sheet1 in column B I have the vlookup:
=(C1,'sheet'!A1:B800,2,false) or
=(C1,'sheet'!A1:B800,2,true)
Can you vlookup with a partial string? I have about 17000 lines that I need to populate with this.