Help with a complicated IF function

Hi,

This is best of my understanding "=IF(Sheet2!G9 > 0, IF((Sheet1!B9=Sheet2!E9),IF((Sheet1!A9=Sheet2!I9),Sheet2!G9,0),0),0)", if not post sample workbook to fetch the desired output.

Vinod

OK thank you.

Sheet one looks like this:
COLUMN 1 COLUMN 2 COLUMN 3
1 A
2 B
3 C
4 D
5 E
6 F
7 G
8 H
9 I
10 J
11 K
12 L
13 M
14 N
15 O
16 P
17 Q
18 R
19 S
20 T
21 U
22 V
23 W
24 X
25 Z
26 A1
27 A2
28 A3
29 A4
30 A5
31 A6
32 A7
33 A8
34 A9
35 A10
36 A11
37 A12
38 A13

and I want the result to be in column 3

sheet 2 looks like this:
Col 1 Col 2 Col 3 Col 4
1 A 23
2 B 24
3 C 25
4 D 26
5 E 27
1 F 27
2 G 0
3 H 0
45 I 0
2 J 0
11 K 34
12 L 37
13 M 38
14 N 59
15 O 60
16 P 36
1 Q 15
2 R 37
3 S 59
4 T 7
5 U 34
22 V 56
23 W 6
24 X 8
25 Z 85
1 A1 3
2 A2 45
3 A3 0
4 A4 0
5 A5 0
31 A6 0
32 A7 7
33 A8 467
34 A9 23
1 A10 412
36 A11 34
37 A12 35
38 A13 568

If the cell in column 1 in sheet 1 is the same as the value in columne 1 in sheet 2, and when the values in column 2 sheet 1 equal the same as the values in column 2 sheet 2 then put all the values that have that criteria onto column 3 in sheet 1. All of this only when the values in the column 3 on sheet 2 are bigger than 0.

Does that help? I dont think I know how to upload a spreadsheet?

Oh! Managed to uplaod it. does tha help?

Right, lets try it with this upload. Is that clearer? I have added a column for "Preffered result".

Unfortunately the cells come up with 0. Let me have another look at this. I think I might have confused myself ;S

Right I know what the problem is, however I dont know how to solve it.

Basically, I pull that formula downwards and the first maybe 100 cells do not have product 1 on sheet two. Therefore, what I need to formula to do is WHEN the first condition (so product name coincide with product name) then simply take the values from the cell with sales on sheet 2. Forget about the greater than 0 thing.

The problem I am having is that I am dragging the formula down, the columns automaticaal go down and when I get down to the column where product 1 is on sheet 1 and on sheet two then excel is already much further down so it doesnt find it.

So basically everytime the product name changes I need it to start looking from the top of the spreadsheet so that the product names can coincide.

Oh god i hope i make sense! Thanks guys for your time... ant ideas?

Still comes up with 0

I think what I am trying to do is too complicated to explain and too complicated to put up in a mock up spreadsheet. There are so many conditions to this, I dont really know where to start.

If i put up a list of conditions, would that help? I am sure the forumla that you gave me is correct, and I also pressed Ctrl, Shift Enter. But there are more conditions that keep creeping up, which is why is doesnt work.

Mockup a more realistic workbook that shows the conditions to be met, and the expected results.
Make sure that the mockup layout is identical to your real sheets layout.

If you post that we might get somewhere.