If then formula

[VbaHell]

I wonder if you can help on this please

This is what i am trying to do

IF B2=C7 THEN B1=B2, IF C2=C7 THEN C1=C2, IF D2=C7 THEN D1=D2, IF E2=C7 THEN E1=E2

This follows the same pattern up to M2=C7 THEN M1=M2

Any help on this would be great please

 

[jasonb75]

In B1 enter the formula

=IF(B2=C$7,B2,"")

Then drag it down to M2 with the fill handle.

 

[VbaHell]

Hi JasonB

I can't use this formula because i have a piece of code that will populate cells in column "B" if cell "B1" have anything in it which includes a formula
This is why I want to only populate the cell if it meets the criteria

 

[BeBoozer]

Will this work:

IF (B2=C7,B1=B2,IF(C2=C7,C1=C2,IF(D2=C7,D1=D2,IF(E2=C7,E1=E2))))

 

[jasonb75]

In that case you will need to do it with more code, maybe a worksheet change or calculate event, depending on whether or not the cell to be monitored for change contains a formula.

 

[VbaHell]

No Beboozer, I don't think this is possible

 

[Zack Barresse]

Hi there,

Jason almost had it. Need to lock the column, not the row. Enter this in B1 and copy to E1:

=IF(B2=$C7,B2)

HTH

 

[VbaHell]

Zack

This is my problem, the code below populates row four in the column that has data in row 1
If i have a formula in the cells in row 1 then this affects row 4
I need only the answer in row 1 if it meets the correct criteria and only one column in row 1 will meet the criteria

LC = Cells(1, 1).End(xlToRight).Column




If LC = Cells.Columns.Count Then Exit Sub
With Cells(4, LC)
.FormulaR1C1 = "=('Total Inventory'!R[37]C+'Total Inventory'!R[42]C)/2"
'.Value = .Value
End With

 

[VbaHell]

I was trying to solve it this way with code

With Range("B1")
.FormulaR1C1 = "=IF(R[1]C=Update!R[6]C[1],'Stock Turn Ratio'!R[1]C,"""")"
.PasteSpecial Paste:=xlPasteValues
End With

So i would just paste the answer but i can't get this to work either

 

[Zack Barresse]

It's very unclear as to how your worksheet is structured. Could you give a detailed description of what your data is, where it's at, and specifics on the expected outputs?