I am trying to lookup all variations of a value within a range of cells. I have a "core" number that I am looking up and I want to find every item in the other list that includes that "core" number.
For example, my "core" number in my raw data is 5402-03. In the list that I am looking in...