One way:

=VLOOKUP("Sales",INDIRECT(A1),2,FALSE)

In article ,
Joe wrote:

When inputting the table_array information in a Vlookup formula you can
either input a range of cells or named range.

My named range changes monthly so I tried to use a cell reference in the
Vlookup formula to capture the new named range but the formula returns N/A#
error?

i.e. cell A1 "Mth_1"

formula: =Vlookup("Sales",A1,2,false)

The formula works is if the named range "Mth_1" is included as part of the
formula instead of reference to a cell that contains the name of the range to
lookup.

Any suggestions? I am trying to make the update process quicker than
performing a fine and replace on multiple tabs.

Thanks