Changing Range Name Within Formula From Another Cells Information

[roamin_oz]

I have 3 Ranges (Range1, Range2 and Range3)

I can easily type a formulas to grad data from either Ranged areas =VLOOKUP(1,Range1,2)

What I would like to do is be able to change the "Range1" within the formula from another cell in the worksheet.

=VLOOKUP(1,K11,2) (K11 cell = Range2) but this returns an error #N/A

Image attached as a reference.



Range-Reference.png

[avk]

Post your file with required result. not pict.

[bebo021999]

Define 3 name "Range1", "Range2", "Range3" by Ctrl-F3 then choose the range and titles.

Assum K11 contain "Range1" (or 2,3)

=VLOOKUP(1,INDIRECT(K11),2,0)

With INDIRECT helps Excel to inteprete text string into cell reference.

[roamin_oz]

Post your file with required result. not pict.

Sorry about that, thought it would be easier showing via a image than file.

Define 3 name "Range1", "Range2", "Range3" by Ctrl-F3 then choose the range and titles.

Assum K11 contain "Range1" (or 2,3)

=VLOOKUP(1,INDIRECT(K11),2,0)

With INDIRECT helps Excel to inteprete text string into cell reference.

Thank you! Works perfectly. I'll have to keep that "INDIRECT" in the mind when I have other ideas!


Not sure how this works, but if I need to make it as solved or someone else. As my problem has now been solved.