Compare 2 coloumn with 2 columnSolved/Closed

Question

Hi friends,
           i want to check two columns with two columns if result is true then want next cell values.

For Example

A        B         C

a         1        10
a         2        20
b         1        30
b         2        40
c         1        50
c         2        60

want to compare D and E with A and B if its match then want to print C

D        E      F (Result)

a        2      20
b        2      40
c        1      50
a        1      10
b        1      30

Kindly reply to my mail rprabhu08@gmail.com

Thanks.....

Regards,
Prabhu.

rizvisa1 · Answer

First I doubt any one would reply to your email as it defeats the purpose of having forum. 

Having said that, Could you please upload a sample file with sample data, Macro, CONDITIONAL FORMAT formula etc on some shared site like https://authentification.site , http://wikisend.com/ ,https://accounts.google.com/ServiceLogin?passive=1209600&continue=https://docs.google.com/&followup=https://docs.google.com/&emr=1 http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too

rizvisa1 · Answer

Could you add a new column in your source table. It would be a formula basically, that would join Location and product into one string. 

Like based on you sample book, in D5, have
=A6 & "|" B6
and drag it to down to last row

you can pick up rate as

=INDIRECT("C" & MATCH(E6 & "|" & F6,D:D,0))

Compare 2 coloumn with 2 column

2 responses

Subscribe To Our Newsletter!