COMPLICATED EXCEL FORMULA [Closed]

Report
Posts
1
Registration date
Sunday October 9, 2016
Status
Member
Last seen
October 9, 2016
-
 x -
Hello Friends,

Can any one help me to sove my problem. I have two excel sheets . i want to comapre column A and B with other sheet and if both cells in sheet 1 matches eaxactly with sheet 2 then return the 3rd adjacent cell to sheet 1.

Here are the sheets,

Sheet 1
A B C
Density Viscosity NUMBER

0.457 3.55 = PUT FORMULA HERE
0.525 3.25
0.606 1.95
0.835 1.95
0.675 2.75
0.746 2.57
0.835 2.38
0.946 2.17
0.457 2.17

Sheet 2

Density Viscosity NUMBER

0.457 3.55 500
0.525 3.25 400
0.606 1.95 300
0.675 2.75 250
0.746 2.57 200
0.835 2.38 150
0.457 2.17 100
1.29 1.71 10
0.835 1.95 50

Expected Result

sheet 1

A B
Density Viscosity NUMBER

0.457 3.55 500
0.525 3.25 400
0.606 1.95 300
0.835 1.95 50
0.675 2.75 250
0.746 2.57 200
0.835 2.38 150
0.946 2.17 NA
0.457 2.17 100


please find a formula ..

Thank you

1 reply

=INDEX(Sheet2!A:C,MATCH(1,(Sheet2!$A:A=A2)*(Sheet2!$B:B=B2),0),3)


Be sure to press CTRL-SHIFT-ENTER to enter this array formula

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!