compare of 2 column value by vlookup example

December 24, 2010 at 02:59:45
Specs: Ms-Excel
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.
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

See More: compare of 2 column value by vlookup example

Report •

December 24, 2010 at 03:21:17
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.

Report •
Related Solutions

Ask Question