Vlookup not working where lookup value contains an apostrophe

[Simon Skelton]

Column A contains a list of names including O'Brien.

Column B contains the result of a vlookup which uses the names in column A
as the look up value. ie Column B2 contains the formula =vlookup(A2 ...
The Array table is on a separate sheet within the workbook.

All look up values except for O'Brien generate the desired result. O'Brien
generates #N/A.

Any suggestions as to what is going wrong?

 

[Max]

It should work fine. Maybe there's a white space somewhere throwing apparent
good matches off. Try using TRIM: =VLOOKUP(TRIM(A2),..
Any good? hit the YES
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[javabean]

Maybe you miss some logic on the function.
Apostrophe doesn't make problem.