Using Hlookup or Vlookup - HELP!!! :)

[43fan]

Not sure even if either one of those is what I'd need/want to use, but
here's the deal.

We have a vehicle schedule here at work(done manually, daily), and
basically, when there's an X in the cell under a particular shift on a
particular day, that vehicle will run. What I want to do is create a list
from that, by shift, by day, for each day, of all the vehicles running. I
thought Hlookup or Vlookup would do it, but it doesn't seem to work the way
I'd want it to.

Here's how the data looks:

Veh# Mon(1) Mon(2) Tues(1) Tues(2)

ABC X X 999 X

In the above, Vehicle ABC would run Monday first and second shift, then not
run Tuesday first shift, then run again Tuesday second shift.

I hope this all makes sense. And actually, on the days they don't run, at
times there are maintenance procedures done, so I could probably use the
same thing to list what's coming due on what day/shift for maintenance.

Thanks!!
Shawn

 

[RagDyer]

Why can't you just print the list you've got, hiding the columns that don't
pertain to a particular day?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Not sure even if either one of those is what I'd need/want to use, but
here's the deal.

We have a vehicle schedule here at work(done manually, daily), and
basically, when there's an X in the cell under a particular shift on a
particular day, that vehicle will run. What I want to do is create a list
from that, by shift, by day, for each day, of all the vehicles running. I
thought Hlookup or Vlookup would do it, but it doesn't seem to work the way
I'd want it to.

Here's how the data looks:

Veh# Mon(1) Mon(2) Tues(1) Tues(2)

ABC X X 999 X

In the above, Vehicle ABC would run Monday first and second shift, then not
run Tuesday first shift, then run again Tuesday second shift.

I hope this all makes sense. And actually, on the days they don't run, at
times there are maintenance procedures done, so I could probably use the
same thing to list what's coming due on what day/shift for maintenance.

Thanks!!
Shawn

 

[43fan]

I suppose that'd be possible, but the list also includes vehicles that
aren't running, and I only want the ones that are.(Those with an "X" in the
cell)