Vlookup not working where lookup value contains an apostrophe

S

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top