Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 23, 2024 10:55 PM
Hi everyone, I want to use the barcode to find the exact record, but somehow it keeps listing relevant records.
My barcode formula is TX1, TX2...
But when I look up the barcode for TX2, it also shows TX20, TX220
Can it be fixed?
Thanks in advance
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 24, 2024 01:55 AM
I don't think so I'm afraid as it doesn't search for identical matches. Perhaps you could try to make your barcode formulas have leading 0s instead?
"TX" &
REPT(
'0',
4 - LEN(Number & "")
) &
Number
 
