VBA vlookup to match 3 set of data

Hi all,

This is the first time posting here as I just cannot figure out a code to VBA and match the column. Currently I am doing it for my workers in an Excel so it can simplify several checking procedure with a click of a button. I only know how to match 1 column using VBA with the QTY.

Excel table.png

So basically I will need the first check be the 4th column to match with the 1st column and the row will move to match. Next will be the 5th column to check and match with the 2nd column and the 3rd check will be 6th column match and check with the 3rd column. The first 3 columns will not be moved and last 3 columns' row will be move together. If there is no match, it will be highlighted RED. As I will need VBA such that with a press of a button it will be match. Thank you very much in advance.

So basically the process flow will be Excel will use the value of Cell A2 to match with value of column D. Thus cell D4 has the same value as cell A2 and the whole row of D4,E4 and F4 will be moved to D2, E2 and F2 respectively. Next row will be the same however the cell F3 has a different value thus will be highlighted red. The 3rd row will also match accordingly. On the 4th row , the column D has the same value but column E do not have the same value thus it will be highlighted red. The column D 5th row do not even have the same value thus it will be be matched at all and just be highlighted red.

So the first criteria will be the column D follow by column E and F. Whenever one of the value dont match, it will be highlighted red. Thank you.

Hi !

No need any code just using the cell conditional formatting …

Something like

Please Login or Register  to view this content.