GetMatch plus VBA Code to Extract Matched Numbers from 2 Single Cells

Hi stanleydgromjr and JBeaucaire

Thank you for your quick response !!

Yes, Mr JBeaucaire is right,

I Post as example and to be short the Match of Cell C6+C9 (with few numbers on each cell)
But in reality there are going to be more than 30 rows combined against other 6 rows to find the match.
and each of the Cell might will have between 12 to 22 Numbers, the Max Number will vary between 36 to 60 (but mostly 36).. (outch...)

Mr stanleydgromjr, i'm noob in excel but i'm trying real hard to learn, and i'm asking my self (please no hard feeling)

Inside the code is the example that i've posted.

'If C6 = 28-17-20-32-21-18-21-40-50-60"
'If C9 = 18-19-20-21-22-23-24-40-50-60"

The question is : the code always will look for those result numbers?


Thank you, and i'm sorry to bother with might (non sense) question (Smile)