N
n8v_nerd
Have 2 worksheets, one is report, the other is a timesheet, sorta...
timesheet setup:
Date | Leave Code | Hours | Reason
Now, on the report page, I have a calendar with the date listed.
What I'm trying to do is Display an "X" if there are NO entries on th
timesheet(otherwords, they weren't absent), and a blank if there IS
match...I got it to halfway work, but MATCH dies if it can't find a
er, match...and returns a #N/A! which makes sense...
=IF(MATCH(L10,Timesheet!E2:E6)=L10," ","X")
** L10 has the date written(the cell with this formula is L12)
Timesheet is the name of the worksheet for Timesheet
Now, the next part...
on L14, If the date is matched, display how many hours(from Timesheet
in the hours colum) and the Leave code(again, from Timesheets, in th
leave code column). It would look like this:
8 LWOP
I know this is kinda a sloppy description of the problem, hope I didn'
confuse you too much
timesheet setup:
Date | Leave Code | Hours | Reason
Now, on the report page, I have a calendar with the date listed.
What I'm trying to do is Display an "X" if there are NO entries on th
timesheet(otherwords, they weren't absent), and a blank if there IS
match...I got it to halfway work, but MATCH dies if it can't find a
er, match...and returns a #N/A! which makes sense...
=IF(MATCH(L10,Timesheet!E2:E6)=L10," ","X")
** L10 has the date written(the cell with this formula is L12)
Timesheet is the name of the worksheet for Timesheet
Now, the next part...
on L14, If the date is matched, display how many hours(from Timesheet
in the hours colum) and the Leave code(again, from Timesheets, in th
leave code column). It would look like this:
8 LWOP
I know this is kinda a sloppy description of the problem, hope I didn'
confuse you too much