I used VLOOKUP, MATCH, INDEX and even the Fuzzy add-on. I'm sure one of these or a combination might work, I just don't have the know-how to make it work and get "#N/A" all the time...
Problem: I have 2 columns, with the different total number of items, full of references. One has partially the same numbers from the other, with some changes, like so:
Column A typical number (ex): 025983553-1 Column B typical number (ex): 225983553
But I have thousands of numbers and I want to match each cell from A to the entire range of B and if there's a match, even in cell B6544, I want o know and get something (in column C) like "True B6544".
A (small) example of what I'm dealing with (and not the exact references, those are in-house sensible data):
B J H 1 025983553-1 225983553 True, B1 2 025973223-1 222222345 False 3 025965463-2 233444667 False 4 025911122-4 211198989 False 5 025998764-1 212989238 False 6 025925925-3 224397501 False 7 025900000-2 225973223 True, B2 8 025999999-5 223334445 False 9 025965453-6 211100110 False 10 025943536-2 225911122 True, B4 ...
As you can see, J1 is a partial match to B1, so H1 returns "True, B1".
As said above, I tried MATCH, VLOOKUP, INDEX and the Fuzzy add-on. I understand that I have to so something like:
=VLOOKUP(B1, $J$1:$J$10, valueThat IwantIThink, FALSE)
But nothing seems to work... any help will be appreciated!