# what if data table

1. ### Data Tables (What-if-analysis) with Powerpivot

Hi, I have an Excel model that uses historical data as one of its inputs. The historical data is voluminous, hence instead of importing into excel and using VLOOKUP (or something similar), i opted to putting the huge database into MS Access, and then import into Powerpivot and using RELATED to...
2. ### How to match 3 variable cells

HI, I am trying to find a way for below problem, any help be highly appreciated. I have 2 cells for example C2 and D2, Which are dependent on A2, for example Changing A2 will change both C2 and D2. Question: if i want to achieve C2=80 and D2: 30, then A2 should be 5. given this scenario how...

Hi All, I'm looking to do a two-variable what-if sensitivity analysis, however, instead of just doing a simple sensitivity to a row cell and a column cell, I would like to shift an entire array as the column and row variables (see below). The reason being that I have multiple "consumer...

Hi All, I'm looking to do a two-variable what-if sensitivity analysis, however, instead of just doing a simple sensitivity to a row cell and a column cell, I would like to shift an entire array as the column and row variables (see below). The reason being that I have multiple "consumer...
5. ### newbie question "what if" function two variables (data table)

I am trying to learn how to use the "what if" function with two variables. Tried to find something in the Forum but in vain. To do this I have read Excel for dummies and here I ran into a Problem: How does What if" function work... I followed the books example and when that did not cut it I...
6. ### Rank Hypothetical value against list of actual values

Greetings Mr. Excel forum! I'm pretty good with excel and formulas, but I'm having some issues getting a simple rank formula to work on hypothetical data. I have a workbook that contains a list of several team members, ranked by their various levels of performance on one tab. On another tab...
7. ### DSum in What if Data Table

I have a list of products and units. I used the DSUM function to sum the specific product units. I place the product name in the criteria field of the DSUM function. I have 10 DSUM funtions with 10 different criteria areas and a different product name. Wanted to see if I could place the DSUM...

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...