Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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
See more

1 reply

Answer 1 / 1 

=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
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!