View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default VLOOKUP and LEN/ISNA to match names?

My THOUGHT was to build on BOTH sheets a column that contained values
you could then match - but I can see that if the data is formatted in
such a way that you CANNOT do it you are going to have problems -
possibly counting the instance of the surname and matching off the
unique values, then working through the rest would be a possible
solution - especially if this is a one off or occassional event!