Hi Guys and Gals
I am improving my database project by adding a multiple axis lookup to create some analyticals. I am trying to fill a table in worksheet4 from the results of the look up from worksheet3
Database example:
Excel 2010
<tbody>
</tbody>
Dropdown1: Date in Month (December)
Dropdown2: Product (L/S, C/S)
Dropdown3: Data (Data1, Data2, Data3)
If I select (December, L/S, Data1) the results will populate in another table like this:
Excel 2010
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Thanks in advance
Regards
I am improving my database project by adding a multiple axis lookup to create some analyticals. I am trying to fill a table in worksheet4 from the results of the look up from worksheet3
Database example:
Excel 2010
A | B | C | D | E | |
---|---|---|---|---|---|
1 | Date | Product | Data 1 | Data2 | Data3 |
2 | 1-Dec | L/S | 5 | 4 | 1 |
3 | 2-Dec | L/S | 4 | 7 | 4 |
4 | 3-Dec | C/S | 6 | 9 | 3 |
5 | 4-Dec | L/S | 4 | 0 | 6 |
6 | 5-Dec | C/S | 5 | 2 | 7 |
<tbody>
</tbody>
Sheet3
On worksheet4 I will have three Dropdown menus with the following information.Dropdown1: Date in Month (December)
Dropdown2: Product (L/S, C/S)
Dropdown3: Data (Data1, Data2, Data3)
If I select (December, L/S, Data1) the results will populate in another table like this:
Excel 2010
A | B | C | |
---|---|---|---|
12 | 1-Dec | L/S | 5 |
13 | 2-Dec | L/S | 4 |
14 | 4-Dec | L/S | 4 |
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet3
Because I have to show some analytical from the search results I will like for this result to show starting in "A10" or so row. Thanks in advance
Regards