Help to find universal extended VLOOKUP tool

And sometimes there are two options: find and pull up on the first match, or to find and pull all matches.

vlookup will only ever return the 1st "find" - after that, it stops looking

I think you could take a look at using INDEX/MATCH, it works like VLOOKUP (also only returns the 1st match)

I think you could take a look at using INDEX/MATCH, it works like VLOOKUP (also only returns the 1st match)

Yes, right. Need IDEX/MATCH in VBA. Just very tired every day to compare large data ranges by formula and became interested in the presence of a universal solution.

In case commercial add-ins, - they usually have a hidden code. I learn VBA for personal use and would like to understand what the code does and be able to understand it.

Anyway will be grateful if anybody advise best index/match tool (preferably one that can have two variants - returns a first value found, or all of the values found). And that can pull up the desired range (1 column or any desired range/columns).

And may be, optional possibility to copy the new (missing) rows from the source file to main. Copy does not match the rows from source at the end of the main table.

Even if it is will be commercial, unfortunately.