Multiple Criteria

Hey Excel Forum Community,

I am in need of some help. I believe this should be an easy fix (well for someone out there), but I can't seem to figure it out. Here what I am looking for. I need to be able see if from Sheet1, the ID numbers in Row 1, appear next to the specific date in Sheet1 column A in the two columns in sheet2 (ex. does ID number 152 (Sheet1 Cell B2) appear on 2/16/2012 from Sheet 2, if it does I want cell B2 on Sheet 1 to say 'Staffed', if it does not appear I want it to say 'Unstaffed'; Does ID number 181 (Sheet1 Cell C2) appear next to 2/16/2012 on Sheet 2 if it does I want 'Staffed' to appear in Sheet1 cell C2, if not I want 'Unstaffed' to appear.). I need to be able to do this for each id number for each date listed on Sheet1.

Also, If the ID number appears multiple times for the same date on Sheet2 I would like to be able to add a column in Sheet1 to show how many times that ID number appears on Sheet2 next to the specified date on . Please advise, I want to learn the formula(s) for both of these solutions I'm looking for but eventually turn this into a Macro.

I hope this all makes sense, if something isn't clear please do not hesitate to ask questions. I look forward to someones help

Sheet1
Column:
152 181 201 222 551 864 1136 1168 1258 etc.
2/16/2012
2/17/2012
2/18/2012
2/19/2012
etc.


Sheet2

1136 2/16/2012
1136 2/16/2012
864 2/16/2012
1459 2/16/2012
201 2/17/2012
181 2/17/2012
1414 2/17/2012
864 2/17/2012
1136 2/17/2012
688 2/17/2012
688 2/17/2012
1168 2/17/2012
1459 2/17/2012
152 2/17/2012
1136 2/17/2012
1414 2/17/2012
1168 2/18/2012
688 2/18/2012
864 2/18/2012
688 2/18/2012
688 2/19/2012
688 2/19/2012
152 2/19/2012
864 2/19/2012
etc. etc.

Please ignore the columns I attempted to put into the thread (formatting threw it all out of whack), I have attached an example spreadsheet...hope this helps

I'm still having issues with attempting to have the vlookup formula (mentioned above) to return a "Staffed" for each date the ID number appears (see second attached spreadsheet). Any advice, suggestions, new formula, vba, etc will greatly help..