I thought I understood data tables but am having difficulty. My output (in this case, IRR) is on the same sheet as my tables. Since I'm using a 2-variable data table, both of my input fields are located on the same sheet as well. I have created a series of tables on this same page but only the first one works. The others are returning different IRRs (output) than they should.
Bookmarks