compare more than two columns

[vinod555]

Hi All,

We have two DATASET. First dataset is column1 and column2. Second dataset is Column3 and Column4.

Column1 Column2 Column3 Column4
Apple 5 Carrot 10
Orange 15 Apple 5
Pinapple 25 Banana 35
Banana 35 Orange 15
Carrot 45 Pinapple 25

I would like to compare like.....

Step 1,First dataset column1 value Apple identify/find second dataset column3 value Apple.
Step 2,If above step is ok,First dataset column1 (Apple) value 5 match with second dataset column3(apple ) value 5.
If both value are same,it should be highlighted in blue color,if not,some other color.

I tried with conditional formatting.but i couldn't find more than 2 columns.

Thanks

 

[NARAYANK991]

Hi ,

Can you upload your workbook with the data in it ?

Narayan

 

[vinod555]

Hi Narayan,

It was uploaded.

Thanks,

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[vinod555]

Hi Narayan,

Thanks for your response......
It is a great.......

=B1 = VLOOKUP(A1, C$1:D$5, 2, FALSE)
=D1 = VLOOKUP(C1, $A$1:$B$5, 2, FALSE)

Is it possible to share what the above statements doing in the excel.

Thanks,