COMPLICATED EXCEL FORMULA

Closed
ggirish008 Posts 1 Registration date Sunday October 9, 2016 Status Member Last seen October 9, 2016 - Oct 9, 2016 at 07:49 AM
 x - Oct 10, 2016 at 12:26 PM
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 response

=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
0