Search for the right function

[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.

 

[Biff]

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