XLookup issue with return array

[Shaner1215]

I’m trying to implement an xlookup array to make it where anytime I put an employees name down on one spreadsheet, It will automatically insert the time frame of the shift in a different spreadsheet for the employees.

I am able to get the Function to get the times to display but it’s displaying both times from the row that it is in when I only want the one corresponding to the shift time shown in the pictures attached.

 

[Peter_SSs]

Welcome to the MrExcel board!

Duplicate to: Xlookup Formula Issue.

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.