I have file need help with formula not working some reason for Time.

[sf49ers19238597]

I have file need help with formula not working some reason for Time.

I have file call NFL Schedule have teams for friends. in time it not display any time that get data from Yearly schedule worksheet. I need new update formula to get the Time working again.

Thanks You very much.

[#2]

@sf49ers19238597 

Edits made:

-updated lookup and return arrays in XLOOKUP (the return array was pointed at an empty column)

- removed spaces before the team names in the schedule sheet

Workbook attached

[#3]

How Do I remove any spaces on worksheet?

Thanks You

[#4]

@sf49ers19238597 

You can use find/replace but must be careful that you select only the cells which might have spaces before doing ctrl+F.

In the Find what: there's one space entered. Replace with is blank

When I removed the spaces from the team names, I made sure I did not select any other cells (even the headers) besides the team names.

[#5]

I try that did not work. I use trim it work have copy and paste value

[#6]

@sf49ers19238597 

Find/Replace could be missing if it's also looking for a cell format. May have to clear it, if set: