Search for the right function

  • Thread starter Thread starter RB
  • Start date Start date
R

RB

I'm being anbitious and trying to put together an excel
program without being an expert. Heres where I come to a
full stop. The program lists in rows jobs undertaken by
my company (Couriers). Various fields such as date,
vehicle, driver, destination etc. After a dozen or so
entries I have a column with drivers names. On the next
sheet I have listed all the drivers working for the co. I
am trying to get the program to look at the drivers
already entered (sheet 1) and put against the list (on
sheet two) something like 'working' or 'available'. The
idea being I can see at a glance whos available. I find
the IF statement works fine for the first name but
returns the wrong answer (False) for any driver after
that.
Any help will be most welcome.
 
Hi RB,

Say your drivers list on sheet1 starts in cell A1:A12. The
complete list of drivers on sheet2 also starts in A1:A100.
In B1 of sheet2 enter this formula and copy down to A100.
Enter as an array by pressing CTRL,SHIFT and then hit
Enter:

=IF(OR(A1=Sheet1!A$1:A$12),"Working","Available")

This assumes that the list on sheet1 is of those drivers
at work. Also note that any time you edit an array formula
you must re-enter as an array.

Biff
 
Back
Top