Hi all, I'm quite new when it comes to using more than basic functions in Excel so im hoping some legend could help me out.
Basically I want that Excel provides the figure adjecent to all of the parameters I choose... For example, this is my list:
CELL.........A..............B..............C..............D.............E
1..............France.......AOP..........2005.........Q2...........$100
2..............France.......AOP..........2005.........Q4...........$105
3..............France.......AOP..........2006.........Q2...........$120
4..............France.......AOP..........2006.........Q4...........$125
5..............France.......ACT..........2005.........Q2...........$90
6..............France.......ACT..........2005.........Q4...........$130
7..............France.......ACT..........2006.........Q2...........$89
8..............France.......ACT..........2006.........Q4...........$119
So far I have a series of drop down boxes to choose the parameters (columns A - B) but I don't know how to get Excel to extract the info from column E based on the parameters.
Beer for someone who can tell me how
N
Basically I want that Excel provides the figure adjecent to all of the parameters I choose... For example, this is my list:
CELL.........A..............B..............C..............D.............E
1..............France.......AOP..........2005.........Q2...........$100
2..............France.......AOP..........2005.........Q4...........$105
3..............France.......AOP..........2006.........Q2...........$120
4..............France.......AOP..........2006.........Q4...........$125
5..............France.......ACT..........2005.........Q2...........$90
6..............France.......ACT..........2005.........Q4...........$130
7..............France.......ACT..........2006.........Q2...........$89
8..............France.......ACT..........2006.........Q4...........$119
So far I have a series of drop down boxes to choose the parameters (columns A - B) but I don't know how to get Excel to extract the info from column E based on the parameters.
Beer for someone who can tell me how
N