I am using excel as a scheduling software for construction. I have certain
phases that may take 1 or more days. I am trying to type in the job number
and have it return all the days each phase is scheduled on.

I currently use the following Vlookup to find the first day:
=VLOOKUP($E$5&$B11,Data!$E$1:$K$16200,4,FALSE)
e5=Job Number
b11=Phase Type
Data!$E$1:$K$16200= the table_array I am pulling from.
4=the co-_index_num

How can I have it return every match for this job number and phase type,
with each match in a seperate row under each other?
--
Thanks,

Ben