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!