fORMULA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phxlatinoboi® - 21 May 2008 09:31 GMT

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

Reply to this Message

Parag - 21 May 2008 10:13 GMT

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

> 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
[quoted text clipped - 21 lines]
> Cooley, Arminda 03/26/08
> Cooley, Arminda 03/27/08

Reply to this Message

Bob Phillips - 21 May 2008 11:17 GMT

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

Signature

---
HTH

Bob

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

>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
[quoted text clipped - 23 lines]
> Cooley, Arminda 03/26/08
> Cooley, Arminda 03/27/08

Reply to this Message