|I don't know what you mean by "compare" the value of 3 columns with value of a different 3 columns.|
Please explain what you mean by that. An an example of the desired output based on the input you have provided might help.
In addition, the fact that you are asking specifically for the use of VLOOKUP leads me to believe that this is a homework problem. If that's the case, we will try to lead you in the right direction, but we won't supply the exact solution.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.