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