View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Sam is offline
external usenet poster
 
Posts: 699
Default Vlookup beginning with 3, 4 or 5 specific values

I need to select values in the second column of a table based on the values
in the first column. Voolkup requires an exact match. My Lookup table is as
follows:

Lab1 35 (I need to match all records that begin with Lab1 and post the
value 35.

Thanks
Sam