Forum Discussion
Unable to Use Logic Functions to Pull Data from Different Sheets
Hi, I am creating a spreadsheet to track employee holidays. If the employee books the full day off, I want the cell under that date and by their name to read "Y". If the employee books the...
In general IFS returns an array which fills all cells from D5 to D503 or so if you are on modern Excel, or first element of such array. Plus some incorrectness in formula, conditions are not met, thus N/A.
I guess you'd like to find employee based on date and email address as ID, when it could be like
=IFERROR(
IF(
LOOKUP(2,1/(Sheet1!C2:C500=January!$D$3)/(Sheet1!B2:B500="test@test.co.uk"))="Full Day",
"Y",
LOOKUP(2,1/(Sheet1!C2:C500=January!$D$3)/(Sheet1!B2:B500="test@test.co.uk"),Sheet1!D2:D500)
),"not found")(not tested)