I'm trying to look up brands using codes that look like this:
I tried to convert everything to text, but it only seems to be converting the numeric only to text (i.e. the 001200 to text and NOT the 0002M), at least by what i see in the little error check that is popping up. I think consequently my lookup is pulling N/A rather than matching it. I've used both index/match and vlookup with the same issue.
What am I doing wrong? If I'm doing a lookup across another table, what's the best format for the above type characters to be in for a proper lookup?