I have to search a given date which is either present or not present in a matrix, and where only the columns are specified. I need to go to specific column (name on top of column), and find in the column whether a given date exists.
I am suggesting a solution based on functions like VLOOKUP, INDEX, MATCH and OFFSET. In this example data table is in D2:H9 and input/output cells are in L2:L4. L2 & L3 are input Machine Name and date and L4 is the binary output.
Formula in L4 is
You need to replicate the formula by adjusting the Input Cell Reference if you need to create more output tables, each representing for a Machine.
This function uses OFFSET to go 100 rows below as length of the table from top. Please adjust this value to match or exceed length of your table in question.
If referring from another sheet precede the cell reference by Sheetname! e.g. Sheet1!D2:H2