match values two sheets

[elmnas]

Hello people,


I been struggling with a function in couple of days now
I hope someone can help me.


I need a code that loops through sheet "mysheet1" on each row and checks the values in Columns "A" and "B"
Example:


(mySheet1)


Columns:[ A ][ B ]
ROW1: SWE ARA
ROW2: SWE DAN



in this case take value from Column A Row 1 = SWE and Column B Row 1 = ARA
(keep them in memory)


then go to sheet "mysheet2"


check any columns as long as the values in this case "SWE" and "ARA" are placed next to each other.






Could someone help me

 

[Menumorut]

Can't you use helper column for concatenate?
Then you would need only to search 1 column each sheet for the same values.

Also your "check" sound more like a countif, what do you want it to do if it find these values?

 

[elmnas]

Can't you use helper column for concatenate?
Then you would need only to search 1 column each sheet for the same values.

Also your "check" sound more like a countif, what do you want it to do if it find these values?

no I have two values like pair I need to find.

SWE and ARA,
and I need to find them as long they are next to each other. if found in "Sheet2" msgbox cells and colour them any color.