using a defined Name in a function
 

I'm having a problem referencing a name within a function.

I have a cell on one sheet that list a defined name. Another cell on a
different sheet uses a vlookup function to return the defined name based on a
date range. then in a third cell I have a vlookup formula that uses the 2nd
cell (the returned defined name) as the "array" but it doesn't seem to
recognize this second cell as a defined name and therefore won't reference
the array. Any suggestions?

using a defined Name in a function
 

you'll have to wrap the text representing the range name in the INDIRECT()
function

"cole" wrote:

I'm having a problem referencing a name within a function.

I have a cell on one sheet that list a defined name. Another cell on a
different sheet uses a vlookup function to return the defined name based on a
date range. then in a third cell I have a vlookup formula that uses the 2nd
cell (the returned defined name) as the "array" but it doesn't seem to
recognize this second cell as a defined name and therefore won't reference
the array. Any suggestions?

using a defined Name in a function
 

That worked fantastic!! Thanks!!

"Duke Carey" wrote:

you'll have to wrap the text representing the range name in the INDIRECT()
function

"cole" wrote:

I'm having a problem referencing a name within a function.

I have a cell on one sheet that list a defined name. Another cell on a
different sheet uses a vlookup function to return the defined name based on a
date range. then in a third cell I have a vlookup formula that uses the 2nd
cell (the returned defined name) as the "array" but it doesn't seem to
recognize this second cell as a defined name and therefore won't reference
the array. Any suggestions?