Hi,
For example,
I want to lookup this table:
And fill up this table using HLookup:
=Hlookup(lookup_value,table_array,row_index_num,range_lookup)
I'm trying to do a HLookup but i want the row_index_num to increase as I copy down the rows.
How do I do this?
Thanks in advance.
For example,
I want to lookup this table:
And fill up this table using HLookup:
=Hlookup(lookup_value,table_array,row_index_num,range_lookup)
I'm trying to do a HLookup but i want the row_index_num to increase as I copy down the rows.
How do I do this?
Thanks in advance.