Hello,
I am really hoping someone can explain the reason for this issue. Whenever I try to copy numerical values that are stored as text and paste them onto another sheet, the #N/A error is returned when an INDEX MATCH is used on the pasted values. This happens even when I try to format the cells as text. The ways to correct this issue are to use the Text to Columns function and selecting text as the format (simple and easy) or edit each cell individually.
Why doesn't formatting the cells as text work (it only does if you edit each cell)? What causes this issue?
Thanks.