Multiple If or And

[mtapp2207]

Hello, I have sheet one that has all the calendar dates and spaces. Sample Sheet a

	WA	WA1	WA2	WA3	WA4
1/1/2019
1/2/2019
1/3/2019
1/4/2019

<tbody>
</tbody><colgroup><col><col span="5"></colgroup>

Sheet 2 has the locations with the dates they are booked.

WA	1/1/19
WB1	1/1/19
NA1	1/1/19
NA2	1/1/19
SA1	1/1/19
SA2	1/1/19
SB	1/1/19
WA	1/1/19
WB1	1/1/19

<tbody>
</tbody><colgroup><col span="2"></colgroup>

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

	WA	WA1	WA2	WA3	WA4
1/1/2019	Booked	Booked	Blank	Blank	Blank

<tbody>
</tbody><colgroup><col><col span="5"></colgroup>

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","")