Excel Function

V

Vicotr

I need to find a way to look for and specific value whithin a range but with
the following characteristics:
Product Country Segment Jan-04 Feb-04 Mar-04
Bankcards Argentina Total 425451 422546 419999
Bankcards Chile Total 87096 86881 86339
Bankcards Colombia Total 116440 116133 116545
Bankcards D R Total 5267 5384 5499
Diners Argentina Total 3198 2863 1513
Diners Chile Total 176 165 235
Diners Colombia Total 1959 1145 1250
Diners D R Total 293 316 514

I would like to find for any given month (variable) the total for Bankcards
and Diners for every country. I try to use the lookup function but I do not
know how to link two variable as the look reference.

I know that I can use pivot table, but I need this to be dinamic.

Can you help?
 
V

vicotr

To be more specific:

I need the sum of Bankcards and Diners for Colombia in Marc 04, but if I use
a cell with the date as a variable the I might need the value for Jan 04 or
for a differnt country.

Regards
 
Top