yogi_From Data In Sheet2 Check Whether Facility 1 to 5 On Specified Dates Is Occupied Or Vacant

Google Spreadsheet   Post  #2415

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Apr-05-2018

question by: Mr. Rich
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/Ez_Ttz2Q42g;context-place=forum/docs

Array Value

How do I fix this?

=IF(INDIRECT(ADDRESS(MATCH(C4,Sheet2!A1:A12),2,,,"Sheet2")):INDIRECT(ADDRESS(MATCH(D4,Sheet2!A1:A12),2,,,"Sheet2"))="","Vacant","Occupied")

Thanks