Hello,
Thanks for looking at this. I will provide a bit of context and then the specific request. I have a formula that needs to be updated. It is an IF formula where the evaluation and if true reference another sheet. I am looking at updating the if false part of that formula. It would also be beneficial if the entire formula could be wrapped in an IFERROR so that the cell does not show an error message if the criteria are false. I have tried to make this work using VLOOKUP and AND. I understand another combination of formulas to use is INDEX and MATCH, but I could not get these to work.
I have provided a dummy file with several tabs, some needed and some just for context.
Specific Request:
I would like the cell in Printable Schedule C4 be updated so the if false part of the formula evaluate two criteria. The first is the name in A4 be evaluated with the range F3:F36 on Scheduling Input. The second criteria is the shift in B4 be compared with the shift in R3:R36 on Scheduling Input. Doing it this way will allow me to drag the formulas down for all 90 rows as it requires both criteria to be correct.
Another way to do this would be just compare one criteria, the name, with F3:F8 and then pull the shift start time over. Setting it up this way would not allow me to drag the formulas down as the three shifts are show by person, rather than by shift.
Ideally, I just want this to work correctly. If there is an easier way of doing it, that would be great.
Thanks for your help with this. If I need to better explain anything, just let me know.
Thanks.
Bookmarks