Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
Can Vlookup look for values in another worksheet | Excel Worksheet Functions | |||
HELP!!! How do you create a query crieria for multi values?? | Excel Discussion (Misc queries) | |||
VLOOKUP FOR MULTIPLE VALUES | Setting up and Configuration of Excel | |||
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions |