I have a spreadsheet that i copied and pasted info into from a different spreadsheet. I then write a vlookup function on a different worksheet to get the matching data. The function only works if I double click the data that I am looking up against the pasted dat
So I would have to double click in Z9 for the function to work. Is this a formating issue or what. Its driving my office crazy!!