Use Text and Cell vale to reference a named range inside a formula

A

Abdul

I have named range in my workbook like AB_Jan10, AB_Feb10 .. etc

and in one sheet I have Jan, Feb, Mar etc as cell values

I want to use a formula something like =VLOOKUP($B4,("AB_" &
TEXT(D3,"mmm")&"10"),3,FALSE) assuming D3 contains a date say 31-
Jan-10 and my named range = AB_Jan10 and want to get the value from
third column in the named range.

Is there a way to get a working formula in Excel

Thanks
 
A

Abdul

=VLOOKUP($B4,INDIRECT("AB_" & TEXT(D3,"mmm")&"10"),3,FALSE)
Click to expand...

Gives me #REF! Error. My range is correct (dynamic) which has five
columns and I am using the same named range in other formulas
(straight forward) which works fine
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named Range that uses "relative" range - Possible? 5
Refer to a named range indirectly 2
Referencing a named range on another sheet 4
How do I have a cell value define a dynamic named range? 15
using indirect to return a named range? 1
a data validation list that contains a list of named ranges - not alist from a named range 1
INDIRECT function to reference a named range 2
Referring to specific cell in named range in Excel formula 3

Top