| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup with multi values
see this response OF FRANK kABEL in the newsgroup posting
http://groups.google.com/group/micro...t.functions/br owse_frm/thread/c41750e2345c7639/ae16ddcb0ec7830f?lnk=st&q=vlookup+all+value s+excel&rnum=8#ae16ddcb0ec7830f "tim" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup with multi values
sorry forgot to caution you. the url is in three lines . highlight all the three lines and paste it in address bar of your browser. "R.VENKATARAMAN" wrote in message ... see this response OF FRANK kABEL in the newsgroup posting http://groups.google.com/group/micro...t.functions/br owse_frm/thread/c41750e2345c7639/ae16ddcb0ec7830f?lnk=st&q=vlookup+all+value s+excel&rnum=8#ae16ddcb0ec7830f "tim" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
