Vlookup using a reference to a named range?(Excel 2000)

[Joe]

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

 

[JE McGimpsey]

One way:

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

 

[T. Valko]

Try it like this...

As long as the named range isn't really a named formula:

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

 

[Joe]

Thx for the fast response - it works great!

Try it like this...

As long as the named range isn't really a named formula:

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

 

[T. Valko]

You're welcome. Thanks for the feedback!