Somebody provided me this lovely formula for my Excel VB code:
MATCH(R[]C1&R[-1]C2
however it currently shows the formula as MATCH($A2&$B1 but cell B1 should read $B$1.
What do I change in the formula to make cell B1 a fixed cell reference?
Just in case it makes a difference the whole formula is:
Range("B2").FormulaArray = _
"=IF(ISNA(INDEX(General!R2C6:R" & LR & "C6,MATCH(R[]C1&R[-1]C2,General!R2C1:R" & LR & "C1&LEFT(General!R2C13:R" & LR & "C13,2),0))),"""",(INDEX(General!R2C6:R" & LR & "C6,MATCH(R[]C1&R[-1]C2,General!R2C1:R" & LR & "C1&LEFT(General!R2C13:R" & LR & "C13,2),0))))"
Bookmarks