PDA

View Full Version : RC FORMULA HELP



olegvolf
05-21-2020, 04:52 AM
Hello,

I am trying to figure out the following code in order
to update columns
please help me

Thanks
Oleg


If Cells(j, 9).Value = "" Then
Cells(j, 9).FormulaR1C1 = "=IF(RC7=""N/A"",""N/A"",VLOOKUP(RC2,Details!C[-7]:C,8,0))"
Cells(j, 9).Locked = True
Cells(j, 9).FormulaHidden = True
End If

Jan Karel Pieterse
05-21-2020, 08:40 AM
You have not mentioned what your problem is?

Paul_Hossler
05-21-2020, 08:56 AM
If you're asking about the R1C1 reference style in the formula

https://www.excelfunctions.net/excel-reference-styles.html