VLOOKUP VBA - both work but ?

[SandsB]

"=IFNA(VLOOKUP(RC[-17],'Pending'!R2C[-18]:R200C[8],3,FALSE),"""")"
"=IFNA(VLOOKUP(RC[-18],'Pending'!RC[-19]:R[198]C[7],5,FALSE),"""")"

The first string was from a macro I recorded way back when. I added the IFNA. The second string is from a macro I recorded today. Both work but I'm trying to understand the different ways the cells are referenced? Is there a functional difference? Is one better than the other for some reason?

 

[MARK858]

R200 is row 200
R[198] is the row 198 down from the cell containing the formula

 

[MARK858]

Just to try and be a bit clearer, if we were putting the formula in cell E8 both codes below would reference H200

Sub testR1()
Range("E8").FormulaR1C1 = "=R200C8"
End Sub

would give the Absolute reference of $H$200

Whereas

Sub testR2()
Range("E8").FormulaR1C1 = "=R[192]C[3]"
End Sub

would give the Relative reference of H200

In your formula it would probably be better to have the lookup range as both absolute row and absolute column