Multiple If or And

[mtapp2207]

Hello, I have sheet one that has all the calendar dates and spaces. Sample Sheet a
[TABLE="width: 395"]
<tbody>[TR]
[TD][/TD]
[TD]WA[/TD]
[TD]WA1[/TD]
[TD]WA2[/TD]
[TD]WA3[/TD]
[TD]WA4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1/1/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1/2/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1/3/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1/4/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col span="5"></colgroup>[/TABLE]

Sheet 2 has the locations with the dates they are booked.
[TABLE="width: 128"]
<tbody>[TR]
[TD]WA[/TD]
[TD="align: right"] 1/1/19[/TD]
[/TR]
[TR]
[TD]WB1[/TD]
[TD="align: right"] 1/1/19[/TD]
[/TR]
[TR]
[TD]NA1[/TD]
[TD="align: right"] 1/1/19[/TD]
[/TR]
[TR]
[TD]NA2[/TD]
[TD="align: right"] 1/1/19[/TD]
[/TR]
[TR]
[TD]SA1[/TD]
[TD="align: right"] 1/1/19[/TD]
[/TR]
[TR]
[TD]SA2[/TD]
[TD="align: right"] 1/1/19[/TD]
[/TR]
[TR]
[TD]SB[/TD]
[TD="align: right"] 1/1/19[/TD]
[/TR]
[TR]
[TD]WA[/TD]
[TD="align: right"] 1/1/19[/TD]
[/TR]
[TR]
[TD]WB1[/TD]
[TD="align: right"] 1/1/19[/TD]
[/TR]
</tbody><colgroup><col span="2"></colgroup>[/TABLE]

I am trying to create a lookup that looks at the sheet 1 date and somehow bring in the results below

[TABLE="width: 395"]
<tbody>[TR]
[TD][/TD]
[TD] WA[/TD]
[TD] WA1[/TD]
[TD]WA2[/TD]
[TD]WA3[/TD]
[TD]WA4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1/1/2019[/TD]
[TD] Booked[/TD]
[TD]Booked[/TD]
[TD]Blank[/TD]
[TD]Blank[/TD]
[TD]Blank[/TD]
[/TR]
</tbody><colgroup><col><col span="5"></colgroup>[/TABLE]


Hope you can understand. Any help is greatly appreciated.

 

[Jonmo1]

Why is WA1 booked ? It's not llisted in Sheet2 (nor WA2 or WA3 or WA4)

 

[mtapp2207]

My typo. Sorry Only WA should show booked.

 

[Jonmo1]

Try this, assuming the tables you posted are at the very top/left of the sheets..

=IF(COUNTIFS(Sheet2!$B$1:$B$9,$A2,Sheet2!$A$1:$A$9,B$1),"Booked","")