Good day,

The content of a cell in 5 different tables (depreciation rates tables) shall be picked up based on Lookup_Value(asset type) that varies from one asset to another.
using the the IF and Hlookup formula can make it manual.
How do I the reference to where the data to be looked up change automatically by linking it to a variable cell: Name of the Table?

=HLOOKUP($O8,Q3,R8+1,FALSE)

=HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)
Information from Excel Help: Table_array is the table of information in which data is looked up. Use a reference to a range or a range name, such as Database or List.
The “Table_array” in the formula(Q3) shall change with each asset type(depreciation table) that varies. How do i make the range or range name (where to look for) change as the content of cells change with different asset type and the Hlookup still give correct answer?

If the range or range name can’t vary is there other way/function to pick a depreciation rate from number of tables?

Thanks and regards,

Dave