Forum Discussion
quilkin
Feb 07, 2020Copper Contributor
xlookup not finding number/letter mix
I have a column consisting of part numbers: a mix of numbers and digit/letter combos, e.g 2, 3, 3a, 4, 5, 6, 6a, 6b, 6c, 7, 8 ...... I have formatted both the source column and the lookup column a...
onethreeone
Apr 27, 2020Brass Contributor
SergeiBaklan That's a terrific solution Sergei! I was having a similar problem with numerical product number with leading zeroes! Using TEXT to define the values as "General" has solved a longterm headache. Thank you.
Matthew
SergeiBaklan
Apr 29, 2020MVP
Matthew, glad to help