Put the value from various excel sheets using lookup : [Closed]

Report
Posts
1
Registration date
Thursday February 13, 2014
Status
Member
Last seen
February 13, 2014
-
In Sheet1,
A B C D
1 15/AA/07 m 100 1000
2 15/AA/08 n 300 3000
3 15/AA/09 p 800 7000

In Sheet2,
A B C D
1 15/BB/07 R 100 1000
2 15/BB/08 S 500 7000
3 15/BB/06 T 800 3000


In Sheet3, what is the formula in A1
If A1=15/AA/08,
Then in A5 must be =3000 (result)
Then in A6 must be =2700, i.e. (3000-300)(result)

*** If A1 matching in Sheet1,Col-A(A1:A10), then put the value from Col-D. If does not match, then search in Sheet2, Col-A(A1:A10), and put the value from Col-D, IN SHEET3, A5.

*** If A1 match in Col-A of Sheet1, Sheet2, then put the value from respective col-D (-) {minus} col-C, IN SHEET3, A6.

with regards,