Hi,

You may want to try my solution on this page

http://office.microsoft.com/en-us/ex...260381033.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"pete8125" wrote in message
...
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.