Hello,
I'm trying to look up brands using codes that look like this:
001200
001200BT
0002M
etc.
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?
Thanks!
Bookmarks