I have a spreadsheet that has a sheet (Assumptions!) that I do not want to change. There are sheets that I can use. I want to make a data table where the variables are in a names range on assumptions! sheet. Is it possible to create the data table? The named range is setup with the first column listing numbers from 1 up, and the first row has numbers for each column. I tried using =index in the data table input cell with no success, maybe because I am not very familiar with index function