I'm going to pull my remaining hair out soon about this. Any help will be
gratefully received. Here we go:

I'm trying to run a VLOOKUP to find the manning of a vehicle which will
appear 4 times under the same name and under different times.

A B C D

1 F101 0630-1830 Smith COVERED
2 F101 0630-1830 Jones COVERED
3 F101 1830-0630 Bloggs COVERED
4 F101 1830-0630 Uncovered UNCOVERED


This is a few columns of a huge package od data that i have to filter down
when the information is automatically refreshing and the "F101" bit changes
its position depending upon the day.

I have sorted that out but i have tried to use VLOOKUP to look for just the
information that i want but it will only look at the very first line and i
need it to give me all four. I have managed to change it so that i only have
to look for one time (0630-1830) but i still just get a duplicate result.

What i receive is

A B C D

1 F101 0630-1830 Smith COVERED
2 F101 0630-1830 Smith COVERED
3 F101 0630-1830 Smith COVERED
4 F101 0630-1830 Smith COVERED


The information that i want will always be on the line below the first
result if that helps with this.

HELP.