G
Guest
How do I reference a cell within a formula based on the contents of another
cell?
For example if one cell contained a reference/address for a column array,
how could I refer to this cell (and hence the column array) within the
vlookup function instead of having to put in the actual table array. In
other words an external way of changing the table array rather than going
into the formula.
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
cell?
For example if one cell contained a reference/address for a column array,
how could I refer to this cell (and hence the column array) within the
vlookup function instead of having to put in the actual table array. In
other words an external way of changing the table array rather than going
into the formula.
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)