Compare 2 coloumn with 2 column

Solved/Closed
Report
-
 Prabhu -
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.

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
if you want Excel filr you can use this link https://authentification.site/files/23164665/Sample.xls

Thanks...
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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))
Thanks Dear.... now its working...