Hi, wonder if its possible. Lets say i have a list of Code, which has 6 digit. Lets say 123456 is Printing and 123457 is Commission. Is it possiible that if i enter 12345x in a cell, then it will return both Printing and Commission? If i enter xxxxx6, it will return printing only. Please see attached for sample.
Bookmarks