How to compare multiple columns in excel?

Posted by musicking123 on Stack Overflow See other posts from Stack Overflow or by musicking123
Published on 2010-03-22T05:43:54Z Indexed on 2010/03/22 6:31 UTC
Read the original article Hit count: 245

Filed under:

Hi

i have two sheets having data like this

sheet1 :
**A**   **B**         **C**
752       A
752       E
752       N
984       G1
984       G2
4471      U1
4471      U2
4471      U4
4471      U5
4471      U7
4471      U8

sheet2:
**A**   **B**    **C**
132       G      69092
227       G      29400
227       G1    2378
292       G     2088
426       G     14419
752       A     180829
752       E     719404
752       N     602180
1173      G     7361
1173    G1  13083
1619    US  108
5804    N   701
5804    SG  8
5819    CA  24
6333    AE  218

What i want is, i need compare sheet1 and sheet2 , if sheet1 A and B columns match with sheet2 's A and B columns then i want the value C (column in sheet2) to be placed in sheet1 column C.

Please help me, i know how to compare only one column with other column by using vlookup, but here i want to compare two columns at a time.

Thanks in advance

© Stack Overflow or respective owner

Related posts about excel-2007