I have a excel file. I want to compare the value of column A to C with column E to G by using "VLOOKUP". Please solved this problem. Plz. give solution with formula.

Regards

Prasanta

examp.

CAG1 NSE~N~2010156 32684.35 CAG1 NSE~N~2010153 32684.35

CAG1 NSE~N~2010157 302.51 CAG1 NSE~N~2010153 -32963.42

CAG1 NSE~N~2010158 -32963.42 CAG1 NSE~N~2010153 302.51

CAG1 NSE~N~2010159 -26932.61 CAG1 NSE~N~2010153 -151.28

CAG1 NSE~N~2010160 -151.28 CAG1 NSE~N~2010153 -26932.61

CAG1 NSE~N~2010161 1157.42 CAG1 NSE~N~2010153 1154.72

I don't know what you mean by "compare" the valueof 3 columns withvalueof 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.

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History