I am trying to write an if/and formula that scans the columns in the 'class list' sheet matching criteria in four of them and then returns the data in the fifth column of that row to the appropriate cell in each day of the week sheet. However, no matter how I structure it, it always returns the false value instead of the data from the class column that I want it to find and return. I have tried changing the order of of the columns in the formula. I have tried using absolute references and mixture of relative and absolute references.
This is the formula I have entered: =IF(AND('Class List'!A:A='Location Specific Data'!F1,'Class List'!C:C='Location Specific Data'!A6,'Class List'!E:E='Location Specific Data'!F2,'Class List'!D:D='Location Specific Data'!F7),'Class List'!$B$182,"----------")
I have attached the workbook.
I want the formula to return the data from the class list sheet column B row 182 to the cell where the formula is on the Sunday sheet.
Thank you, any assistance is greatly appreciated!
Bookmarks