Here is an example,
I want to pull in different line items from a table. Across the top of my table is dates. It is down the left hand side that I am struggling. I want to do 2 things (hence the 3 variable table). I want to look up a certain row number and do this based on a certain scenario. I have thought about using Excel's Scenario tool, but it's not what I'm after.
To be more clear, the value to be calculated in my two-dimensional data table is based on the hlookup formula. The hlookup looks up a certain column (forced by Excel Data Table) and then would look up a certain row (based on the left side variables in the Data Table). This is fine, but I want to do this also for three scenarios.
I don't know if I'm making any sense...