I have copy/pasted (Values (V)) to Columns A and B in a new sheet (attached). In using an INDEX/MATCH formula, the appropriate results are generated until I plug in the time 7:14 into Cell [D32]. Then #N/A appears. Same for plugging in 7:16. Then, the formula works again for 7:17 and beyond. I have used =D32=A32 to see if values are the same, and they are. Now, if I type 7:14 fresh into cell [A32] the formula works. So, there appears to be something invisible and embedded in the original copy/paste data that interferes. Is there a way to “clean” the original data in cells A32 and A33 to allow the INDEX/Match formula to work? Or am I stuck having to type in the time fresh into these two cells? Many thanks!
Bookmarks