Forum Discussion
Autofill the Row_Index_num field on a Hlookup
i am currently creating a table auto populated with Hlookups. the table as formulas looks a bit like this 1 A =hlookup(A1,'Sheet2'A1:A2,[2],False) B =hlookup(A1,'Sheet2'A1:A2,[3],False) ...
=Row() functions shows what the row of a Cell/range where it belongs be ChadBoronow
Example =Row(A1), wil return a value of 1
when you used a Hlookup the row number changes according to the heading (row_index_num) so you need to match the Row() and the value of row according to the Hlookup
The solution is very easy you need find out a number need to be subtracted in Row() to match the row_index_num
Example the
row_index_num is 2
Row(A14) is 14
so you need to subract 12 on Row(A14) so you will have 2
hlookup(A1,'Sheet2'A1:A2,Row(A14)-12,true