IF and AND Statement

December 13, 2011 at 18:30:10
Specs: Windows 7, Intel Core2Duo/8GB
Hi, how would I write a formula for A2:F4 on Sheet 1 to yield a "Y" in B2:F4 and Status (Work, Sick, Vac or blank) in A2:A4 if there are data in A1:B7 on Sheet 2?

Sheet 1

1 12/19 12/20 12/21 12/22 12/23
2 Work Y Y blank Y Y
3 Sick Y blank blank blank blank
4 Vac blank blank blank blank Y

Sheet 2

1 12/19 Work
2 12/19 Sick
3 12/20 Work
4 12/21 blank
5 12/22 Work
6 12/23 Work
7 12/23 Vac

If column B on sheet 2 has another status, then it would be displayed in column A of sheet 1.

Thank you,


Ps. Sorry I forgot how to line up the data in the columns.

See More: IF and AND Statement

December 14, 2011 at 05:39:54
Please click on the following line to access the instructions on how to post data in this forum.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question