I am trying to code a vlookup in my macro and am not getting the desired
results. I want to use a variable (corrng) for the range name in the
vlookup. When I use the formula below, I get "#NAME?" as the result. Any
suggestions on how to use a variable would be appreciated.

ActiveCell.Offset(0, 24).FormulaR1C1 = "=VLOOKUP(RC[-22],(corrng),2,FALSE)"
--
JT

Hi JT,
ActiveCell.Offset(0, 24).FormulaR1C1 =
"=VLOOKUP(RC[-22],(corrng),2,FALSE)"

you need a range named "corrng", this is the matrix (data table) for
your lookup function.

arno