P
pete8125
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.
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.