VBA VLookup Reference Problem

[Scott1523]

I'm trying to simplify the process of vlookups for others and have trie
the following. This is intended to look at the adjacent cell to th
left(containing a branch code) and fill in the corresponding branc
name. I have the Vlookup data on a hidden sheet in the workbook. M
problem is that the lookup range moves with the active cell. Any hel
would be greatly appreciated.
Thanks,
Scott


Selection.FormulaR1C1 = _
"=VLOOKUP(OFFSET(RC,0,-1),Lookups!R[-1]C[-1]:R[43]C,2,FALSE)"


Selection.Copy

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone
SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = Fals

 

[Tom Ogilvy]

Can't tell where your lookup range is from your sample because the
references are relative. Change them to absolute

instead of

Lookups!R[-1]C[-1]:R[43]C

something like

Lookups!R43C7:R200C8 Lookups!G43:H200