VLOOKUP and range name formula

[The Horse]

I can't quite crack this...posts on the web seem contradictory:

I've created a group of formulae and named each one - it's for a cost allocation model.
Then, I've done a table with the approaches in column A and the range names in column B:

A B

Approach 1 Name 1
Approach 2 Name 2

When I've referenced them using vlookup(item,a1:b2,2,0) I can get Name 1 as text, but can't get it to evaluate to the formula which I've stored as Name 1.

In other words, I want the lookup to find the relevant range name and evaluate to the formula embedded in the range name.

Tried vlookup(item,indirect(a1:b2),2,0) but it doesn't work.
Anyone know the answer ?

Thanks

Mick the Horse

 

[Aladin Akyurek]

Aladin,

that is a brilliant solution !!!!!!!!!!!!!
Thank you so much !

Regards

Mick the Horse

Great. Thanks for providing feedback.