Establish Ramp Up Point

[tomjoe]

Hi

I want to combine IF OR and VLOOKUP to make a conditional ”X” in column A.
But something goes wrong. Can anyone help me out on this?

Formula in cell A9:
=IF(OR($C$10>SUM(B9:$B$10);VLOOKUP($F$1;A10:$A$10;1;0));"";$F$1).

See attachment.

Tommy

[DonkeyOte]

@Tommy, could you explain the purpose of the formula in words as I can't really follow what you're trying to achieve (looking at the formula/file).

Once we know the aim of the calculation we can also discuss a better thread title for your post.

[tomjoe]

See new attachment.

-----------------------------------------

This is a small part of a big Excel model.

In cell C10 I have the shortage of capacity during a given period in a production plant. In column B I have the surplus capacity that we can use to cover up the shortage. I want the model to put a text (“X” or “Ramp Up”) in the week when we have to start using the surplus capacity in order to not get sold out.


Week Ramp Up Surplus Shortage
1 200
2 100
3 50
4 X 50
5 100
6 150
7 200
8 500 1000

[DonkeyOte]

OK I think I understand (working from bottom up), using the most recent sample file:

B2:
=IF(OR(COUNTIF($B3:$B$10;"X");$D$10>SUM($C2:$C$10));"";"X")
copied down to B9

Now we know what you're doing we can retitle your thread to something more appropriate.
Please try to keep titles specific to the problem itself.