i am currently creating a table auto populated with Hlookups. the table as formulas looks a bit like this
When i try to use the drag feature to autofill rows below it doesnt realize i want the bracketed number ( & ) to go up by one for each row and therefore i have been manually changing the number to fit the line it is on. I have to do this for 999 lines however and was wondering if anyone knew of way to get this to autofill
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.
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!