Lookup Intersection using Multiple Criteria and Return Value


New Member
Apr 12, 2016
Thanks for taking the time to look into this for me.

Here is the issue that I've been trying to fix for about a week.

I would like to email you the attachment if you're going to help me out because for some reason, I am not allowed to add attachments to my post and it would be really beneficial for you to see the Excel Workbook.

The goal is to populate the Code fields with the appropriate information.

The information can be retrieved by matching a couple criteria. The first criteria is that the Date on the 24HR Sheet matches the one of the available dates on the Time Sheet and uses it’s column to retrieve the information. The second criterion is that the name on the 24HR Sheet to the left of the code matches up with the one on the Time Sheet and uses their row to retrieve the information. So basically, I am trying to do an intersection on the Time Sheet that checks the date and person’s name to give me their shift. Once the shift is received, I’d like to convert it to the appropriate code and have it populate the cell.

If a cell is blank/empty, I’d like to skip it without leaving a corresponding blank cell on the 24HR sheet like the cells containing their names on the 24HR sheet.

The Shifts and Codes are located on the Resources tab.

I hope I have clarified this enough for you and if not, please let me know what I can do to clarify it further.

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics