fORMULA

[Phxlatinoboi®]

I need help with an "if" formula. I have a spreadsheet that in column a it
lists the employee's name and then in column b it lists the date the employee
was at work. On a different spreadsheet i have listed a row of scheduled days
of work. I would like to have on this spreadsheet to make an X if the
employee has that date next to the name. How can I do this?

Cooley, Arminda 03/03/08
Cooley, Arminda 03/04/08
Cooley, Arminda 03/05/08
Cooley, Arminda 03/06/08
Cooley, Arminda 03/10/08
Cooley, Arminda 03/11/08
Cooley, Arminda 03/12/08
Cooley, Arminda 03/13/08
Cooley, Arminda 03/14/08
Cooley, Arminda 03/15/08
Cooley, Arminda 03/17/08
Cooley, Arminda 03/18/08
Cooley, Arminda 03/19/08
Cooley, Arminda 03/20/08
Cooley, Arminda 03/21/08
Cooley, Arminda 03/24/08
Cooley, Arminda 03/25/08
Cooley, Arminda 03/26/08
Cooley, Arminda 03/27/08

 

[Parag]

Hi,
Use this formula in column C.
=IF(MATCH(B1,Sheet2!$A$1:$A$3,0)>0,"X","NotPresent")

where
1) Column B contains dates.
2) Column A of Sheet2 contains list of scheduled days. Now, you may have to
change the formula as per no of days in your list.

--Parag

 

[Bob Phillips]

=IF(ISNUMBER(MATCH(B1,Sheet2!$A$1:$A$3,0)),"X","")


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)