Hi guys, I need to do a horizontal look-up (=HLOOKUP) in a document with 5.000 individual rows.
The formula is as follows: =HLOOKUP(lookup_value;table_array;row_index_num;[range_lookup]).
Of this formula the third part of the equation is the problem, as it is not possible to slide it down. Does anybody have a solution?
Thanks!
Bookmarks