Hello, I'm looking for some help cross referencing two tables. I've tried a number of VLOOKUP, MATCH, INDEX and array formulas I've found researching similar problems, but cannot seem to find one that will return a valid result.
My database is comprised of 98 contractor names (Col A), all with spaces. My look up range is another column containing another 1150 contractor names (Col B), that due to import difficulties, do not have spaces, so I cannot perform an exact match. I need to search Column B using the names from Column A to see which are listed in both.
For example, in Column A we would have 3K TECHNOLOGIES LLC, and somewhere within Column B, it will be listed as 3KTechnologiesLLC. I need a function that will check each value in A, and return it's location in B. I was thinking that using a partial text match, I could just match the first 5 characters, to circumvent looking for an exact match.
Any help is appreciated!
My database is comprised of 98 contractor names (Col A), all with spaces. My look up range is another column containing another 1150 contractor names (Col B), that due to import difficulties, do not have spaces, so I cannot perform an exact match. I need to search Column B using the names from Column A to see which are listed in both.
For example, in Column A we would have 3K TECHNOLOGIES LLC, and somewhere within Column B, it will be listed as 3KTechnologiesLLC. I need a function that will check each value in A, and return it's location in B. I was thinking that using a partial text match, I could just match the first 5 characters, to circumvent looking for an exact match.
Any help is appreciated!
