View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KHogwood-Thompson KHogwood-Thompson is offline
external usenet poster
 
Posts: 16
Default VLookup & Case Sensitivity

Hi All,

I am trying to compare two spreadsheets of text strings, I only want to find
those that match content and case. Currently Excel says that they match even
if the case is not matching ie

Follow Up is not the same as Follow up

But with my current standard vlookup statement, Excel returns these values
as matching.

Please can someone help.

Thanks
--
K Hogwood-Thompson