Forum Discussion

ChadBoronow's avatar
ChadBoronow
Copper Contributor
Jan 31, 2019

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)   ...
excel
ChadBoronow's avatar
ChadBoronow
Copper Contributor
Jan 31, 2019
as in replace the hlookup with a row function or replace the constant within the hlookup with a row function? I tried plugging in a row function as the constant in the hlookup and it did not work, and I do not think I will be able to run the table as i need to without the hlookup.

Thanks for taking the time to respond and help!
  • ChadBoronow's avatar
    ChadBoronow
    Copper Contributor
    Jan 31, 2019
    Oh I see, i was thinking i had to plug in a starting cell in the () in Row()+1. I had a small problem with the starting result being 2 rows below where my data starts, but was able to simply shift my table down to make it work.

    Thanks again for the help I got it working how i need now!
    • SergeiBaklan's avatar
      SergeiBaklan
      MVP
      Jan 31, 2019

      You may use ROW()+something, e.g. ROW()+ROW($A$1) if A1 is your header cell, or like 

Resources