Biff this worked great until I inserted more rows since I hadn't recieved a
#NUM yet. Now all the cells come up with #N/A.

How did I mess that up?

--
Thanks,

Ben


"Biff" wrote:

> Hi!
>
> Here's one way.
>
> Column 4 in your table array is column H.
>
> Entered with the key combo of CTRL,SHIFT,ENTER:
>
> =INDEX(Data!H:H,SMALL(IF(Data!E$1:E$16200=E$5&B$11,ROW($1:$16200)),ROW(1:1)))
>
> Copy down until you get #NUM! errors meaning all matches have been found.
>
> If you don't want to see the #NUM! errors you could suppress their display
> by including an error trap in the formula. This makes the formula twice as
> long and since you're looking through a large range, may "slow" things down
> a bit. An alternative is to use conditional formatiing to "hide" the errors.
>
> Post back if you need further assistance in dealing with the #NUM! errors.
>
> Biff
>
> "Ben" <Ben@discussions.microsoft.com> wrote in message
> news:31C5603C-AF2D-4C11-A79E-FC2EFA299165@microsoft.com...
> >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
>
>
>