Hello,
I have been spending more than 1 hour to figure this out myself but I think now I need some help. I have everything on my worksheet setup in the way I like it except for the formula in column G. Essentially, I am using an INDEX formula get the a random sample from the worksheet 'Data' returned to worksheet 'Random sample generator'. The formula I already have does this just fine, however I would like the INDEX formula to use/pick the cell range from the content of another cell, via INDIRECT but I can't get this to work.
My current formula looks like this but I want the $A$2:$A$20230 to be picked from the cell D19 and D20
HINT: This workbook contains some VBA code however, it does not need to be used, activated or executed. It generates some random numbers and inserts them in column F. The workbook also contains some random numbers, so the formula and lookup work without the VBA.
Thank you!
Bookmarks