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

Question

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.

patrick2788 · Answer

sf49ers19238597&nbsp;&nbsp;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&nbsp;Workbook attached

sf49ers19238597 · Answer

How Do I remove any spaces on worksheet?Thanks You

patrick2788 · Answer

sf49ers19238597&nbsp;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&nbsp;&nbsp;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.

sf49ers19238597 · Answer

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

patrick2788 · Answer

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

Forum Discussion

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

5 Replies