Forum Discussion
Nested IF function with multiple cells for comparison
Hello,
Allow me to explain what I am trying to achieve. I have 2 worksheets of data with a common field of an ID #. In sheet 1, the ID # is in cells F2:F88. In sheet 2, the ID # is in cells F2:F...
Hi Lori,
If your end goal is to produce a list of ID's from Sheet1 that do not have a data match on Sheet2, then you can depend only on the ID in the matching process, you don't have to check the start date and the end date of each record.
So you can use this formula in cell I2 of Sheet1 to find the records that aren't in Sheet2:
=IF(ISNUMBER(MATCH(F2,Sheet2!$F$2:$F$48,0)),"Y","N")
Please find the attached file.