View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tim
 
Posts: n/a
Default Vlookup with multi values


This is a weekly work schedule 1 sheet is vacations another personal and
so on. What I want is on a new sheet the ability to key in a date that
would look at column A1:A100 on the vacation sheet and bring back the
info from column B1:B100 it could be as many as 10 matches in column A.
Is this just a pipe dream or can this be done.


--
tim