xls
06-19-2010, 07:43 AM
Hi following is example of table in which data is available:
I want data from table which specifies condition1 = a, condition 2 = 3 & Month=2. How to find out using formula.
Cond. 1.....Cond. 2.......Month1..........Month2..........Month3
......a.............. 1..............Data1............ Data12.............Data13
......a.............. 2..............Data2............ Data12.............Data13
......a.............. 3..............Data3............ Data12.............Data13
......a.............. 4..............Data4............ Data12.............Data13
......a.............. 5..............Data5............ Data12.............Data13
......b.............. 1..............Data1............ Data12.............Data13
......b.............. 2..............Data2............ Data12.............Data13
......b.............. 3..............Data3............ Data12.............Data13
......b.............. 4..............Data4............ Data12.............Data13
......b.............. 5..............Data5............ Data12.............Data13
Pl help
I want data from table which specifies condition1 = a, condition 2 = 3 & Month=2. How to find out using formula.
Cond. 1.....Cond. 2.......Month1..........Month2..........Month3
......a.............. 1..............Data1............ Data12.............Data13
......a.............. 2..............Data2............ Data12.............Data13
......a.............. 3..............Data3............ Data12.............Data13
......a.............. 4..............Data4............ Data12.............Data13
......a.............. 5..............Data5............ Data12.............Data13
......b.............. 1..............Data1............ Data12.............Data13
......b.............. 2..............Data2............ Data12.............Data13
......b.............. 3..............Data3............ Data12.............Data13
......b.............. 4..............Data4............ Data12.............Data13
......b.............. 5..............Data5............ Data12.............Data13
Pl help