How to make a "table_array" cells selection dynamic in a search function

[TheRox]

I was wondering whether someone could help me on this.
When using a search function, for istance a Hlookup function, I need to specify the following parameters: lookup_value; table_array; row_index_num; range_lookup.

I don't have problems with "lookup_value" since I can refer it to a cell that contains a number and it works OK; same goes with row_index_num and range_lookup.

However, I don't find a way to correctly fill the "table_array" parameters using text. I am defining the "table_array" as text referring to a range of cell, using "B8:J12" in my exemple, and I get a "#N/A" answer. I can't find any other way than to manually select a range of cells, which I want to avoid.
What text format should I use, or is there a function I need apply to make the search function work? Is it a syntax issue?

What I want to achieve is using dynamic cell selection to automate the search function.
For ease of reference I have attached a sample excel file to illustrate my query.

Thanks for looking into this.

[Special-K]

Use INDIRECT()

=+HLOOKUP(B21,INDIRECT(B22),5,FALSE)