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
 
Ad

Advertisements

A

Abdul

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

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

Top