I have data like this:
Month Salesman Region Product Customers Net Sales Profit / Loss
Jan-07 Joseph North FastCar 8 1,592 563
Jan-07 Joseph North RapidZoo 8 1,088 397
Jan-07 Joseph West SuperGlue 8 1,680 753
Jan-07 Joseph West FastCar 9 2,133 923
Jan-07 Joseph West RapidZoo 10 1,610 579
Jan-07 Joseph Middle SuperGlue 10 1,540 570
Jan-07 Joseph Middle FastCar 7 1,316 428
Jan-07 Joseph Middle RapidZoo 7 1,799 709
Jan-07 Lawrence North SuperGlue 8 1,624 621
Jan-07 Lawrence North FastCar 6 726 236
Jan-07 Lawrence North RapidZoo 9 2,277 966
Jan-07 Lawrence West SuperGlue 6 714 221

Question:
Need to find total sales in Jan-08,Feb-08,March-08 for salesman=Lawrence and Region=West using VLOOKUP,INDEX&MATCH functiions??
Already solved using SUMIFS,SUMPRODUCT,SUM Functions,what i need is i am stuck in using INDEX&MATCH,VLOOKUP.
Just check my formula to make changes:
Here columns B=Month C=Salesman,D=Region E=Product
=INDEX($G$4:$G$1082,MATCH(U4&W4&{“Jan-08″,”Feb-08″,”Mar-08”},($C$4:$C$1082)&($D$4:$D$1082)&($B$4:$B$1082),0))
=VLOOKUP(U4&W4&{“Jan-08″,”Feb-08″,”Mar-08”},CHOOSE({1,2},$C$4:$C$1082&$D$4:$D$1082&$B$4:$B$1082,$G$4:$G$1082),2,0)