I'm trying to compare two columns, say "A" and "B", and if there is a match i'd like to produce the value "retired" in column C. I am really just wanting to work off column A and see if any values in column B match up with column A. Most the values are in a similar style to "abc123456" or can even just be numbers like "123456". The problem I am having is I'm really just wanting to compare the numbers, and if there is any match on column A then produce "retired" on column C. The numbers are not on the same rows, and I'm wanting to search the whole column to look for a match. I have tried different syntax's and even using Fuzzy Lookup(as recommended here before), but the problem I'm having with Fuzzy is it is seeing that the beginning is different(such as "abc123456" and "xyz123456") and it is skipping those and not matching it up in any aspect of ratio, even though all the numbers are in fact matches. Any help would be greatly appreciated, I feel like I have overlooked something. Thanks.
Last edited: