Are there such things as variables within an Excel formula? - Stack ...

You could define a name for the VLOOKUP part of the formula. Highlight the cell that contains this formula; On the Insert menu, go Name, and click Define; Enter a  ...

stackoverflow.com