Xlookup Formula Issue.

[Shaner1215]

I am trying to make 2 separate Employee Schedules, One has a list of every employees name and the shift location and time for each day of the week. The other is a daily schedule that shows which shift they are working and time for that specific day.

For each day I used the formula =XLOOKUP("Test Name",FRI!C4:C33&FRI!N4:N33,FRI!B4:B33&FRI!M4:M33) into each bigger box. When I fill out the other sheet. I highlight all of the Columns in Row C and Row N as my Lookup array and Columns B and M as my Return Array.

When I put the name into this spreadsheet here. The formula gives me this as a result, Pulling both times from row 21 when i only want the 5:00-10:45 time.

How do I make it to where it would only display the 5:00-10:45 time and not both.

Sorry for not being able to use Xl2bb as I only have access to this file at work.

 

[rcocrane99]

Not sure if this is correct or not but when you add the "&" symbol its might add two returns. =XLOOKUP("Test Name",FRI!C4:C33&FRI!N4:N33,FRI!B4:B33&FRI!M4:M33)
=XLOOKUP(B4,D4:D9,E4:E9&G4:G9)

 

[rcocrane99]

Not sure if this is correct or not but when you add the "&" symbol its might add two returns. =XLOOKUP("Test Name",FRI!C4:C33&FRI!N4:N33,FRI!B4:B33&FRI!M4:M33)

View attachment 121014

sorry forgot to add the formula =XLOOKUP(B4,D4:D9,E4:E9&G4:G9)