Vlookup with IF, AND, and ISBLANK statement

[GuitaristJLN]

Hi guys I was wondering if there was a way to do a Vlookup with an IF, AND, perhaps even an ISBLANK statement and what that formula would look like for the following scenario.

I am trying to create a worksheet that will allow me to type in a restaurant ID and it tell me if It is closed on Saturdays by returning YES or NO. The raw data has thousands of entries so I wanted to create a bit of a dashboard where it returns YES or NO if two fields (Saturday inside-dinning & Saturday Drive through) are BLANK. If it has data in either one of the Saturday Inside-Dinning hours or Saturday Driv through hour fields then it should return YES.

So as a visual I want to type in the restaurant id and it display like the following:

Restaurant ID	Does the location have Saturday Hours?
112	YES
113	NO

The Raw data would look like this (Table/worksheet name is Restaurant Hours) :

Restaurant ID	M-F Hours	Saturday Inside-dinning hours	Saturday Drive through hours
112	8-5	11-4
113	8-5

I am learning more advanced excel as part of my new job role but was asked to help in creating the formula for the above scenario and don't even know where to start so I would really appreciate any help from you guys.

 

[6StringJazzer]

Please try this, where A2 is the restaurant ID to look up:

=IF(AND(VLOOKUP(A2,'Restaurant Hours'!A:D,3,FALSE)="",VLOOKUP(A2,'Restaurant Hours'!A:D,4,FALSE)=""),"NO","YES")

 

[Fluff]

Hi & welcome to MrExcel.
How about, for xl365

+Fluff 1.xlsm
	A	B	C	D	E	F	G
1	Restaurant ID	M-F Hours	Saturday Inside-dinning hours	Saturday Drive through hours		Restaurant ID	Does the location have Saturday Hours?
2	112	8-5	11-4			112	Yes
3	113	8-6				113	No
Lists

Cell Formulas
Range	Formula
G2:G3	G2	=IF(MAX(--ISTEXT(FILTER($C$2:$D$3,$A$2:$A$3=F2,"")))>0,"Yes","No")