View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hilton Hilton is offline
external usenet poster
 
Posts: 35
Default Appropriate function?

I have a lookup which produced 200 matches (180 unmatched).eg
G_100-01_LS Match
G_101-01_LS Match
G_102-01_LS Match
G_101-01_MN No Match
G_102-01_MN No Match
G_101-01_PV No Match
G_102-01_PV No Match


I would like a function that would allocate
G_101-01_MN, G_102-01_MN
G_101-01_PV, G_102-01_PV

as partial matches based on the G_101-01 and G_102-01 prefixes. Can this be
done?
Also would this function act on the original lookup list or on the resulting
list as above?

Thanks
Hilton