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

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

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