PDA

View Full Version : Match values from different columns



elmnas
08-05-2015, 01:28 AM
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

Aussiebear
08-07-2015, 04:34 PM
Could someone help me

Aren't you being assisted already over at MRExcel?

I note that yet again, you have cross posted without notifying others that this issue is already posted elsewhere. Becoming known as a serial cross poster may well work against your being assisted on any forum in the future. You really don't want that do you?