LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Match function with duplicate values in an array Richard Excel Worksheet Functions 3 April 22nd 23 07:45 PM
Can Vlookup look for values in another worksheet tapaspanda Excel Worksheet Functions 1 September 21st 05 01:14 AM
HELP!!! How do you create a query crieria for multi values?? JamesS Excel Discussion (Misc queries) 0 June 17th 05 11:45 AM
VLOOKUP FOR MULTIPLE VALUES RITA Setting up and Configuration of Excel 1 February 10th 05 11:42 PM
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? Steve Excel Worksheet Functions 0 January 30th 05 09:11 PM


All times are GMT +1. The time now is 06:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"