Thursday, April 5, 2018

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

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