i want to match sheet2 with sheet1 WHERE
sheet1 is the master sheet and has all columns. sheet2 has only two columns as in below demonstration and other are to be looked up in Sheet1(master sheet). values in "date" and "ID" may repeat but both together "date" and "ID" makes a unique value. so "Date" and "ID" are to be matched simultaneously(together). it should turn an null value (N/A) if find no match in Sheet1.