Next one, a weird problem I've seen once before. I have a medium-sized data set from some random, likely old, database. Customer name, mailing address, purchase history and such. I need to vlookup some more data in from a second spreadsheet. As per usual I copy the data from that second spreadsheet onto a new, empty sheet in the OG, do a conventional vlookup with the customer name and BAM.
No bam this time. I see the customer's row in each sheet but it doesn't pull the info over; just a #N/A or whatever. Here's the weird part. I add a new row to the spreadsheet, manually type the customer's name in the cel, EXACTLY the same, and the vlookup. It pulls the data for the manually-typed cel, but not for the cel that came with the data set. It's like "Mike Johnson" is in a format you and I can see, but Excel recognizes it as something else.
I copied the original data set and pasted "values only" in a fresh sheet. Formatted the column as text. All no joy.
Am I fooked?