Hi
This is giving me a big headache
I'm trying to find a number closest to 100 in Column Sheet1!$J$2:$J$131106
(1st IF) But only in the rows where a certain date (Sheet2!W16) matches in column Sheet1!$C$2:$C$131106
(2nd IF) and for rows where another certain date (Sheet2!$F$18) matches in column Sheet1!$F$2:$F$131106
(3rd IF) and for rows where a specific letter - either P/C ($G21) matches in column Sheet1!$H$2:$H$131106
I have no idea why, but my formula ignores the 2nd if and just takes whatever date it wants from that column but follow through with the two other IFs.
This is the formula:
This is the data if needed - https://www.dropbox.com/s/8mxnl2rx6a...e123.xlsx?dl=0
The formula is used in cell AA16 in sheet 2
Bookmarks