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

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

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

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

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

Try it like this...

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

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


--
Biff
Microsoft Excel MVP


"Joe" wrote in message
...
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

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

Thx for the fast response - it works great!

"T. Valko" wrote:

Try it like this...

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

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


--
Biff
Microsoft Excel MVP


"Joe" wrote in message
...
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

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

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Joe" wrote in message
...
Thx for the fast response - it works great!

"T. Valko" wrote:

Try it like this...

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

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


--
Biff
Microsoft Excel MVP


"Joe" wrote in message
...
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