View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andy Andy is offline
external usenet poster
 
Posts: 414
Default Vlookup not finding matches

I have two data sets each 3 columns wide, I am trying to match the data in
the first set to the second set. Most of the time the vlookup formula I am
using works fine, however, it does not work all the time. There are data
elements in the sets that are not matching. I have tried reformatting the
cells to ensure they are the same. I have the fourth argument set to FALSE to
find an exact match.

I believe I have tried everything I can think of and am very frustrated. Any
help would be most appreciated.
--
Andy