Another problem with your vlookup formulas is using mixed references
-- A1 for the 1st argument and R1C1 for the 2nd. There are two
options:
- FormulaR1C1 with R1C1 references for both arguments
- Formula with A1 references for both arguments.

Hth,
Merjet