Try something like:

assuming on Sheet 2 you have.. A2:A9= country list, B2:B9= A or B, C1:G1=
months, C2:G9 range with values to lookup.

=INDEX(Sheet2!$C$2:$G$9,MATCH(I9,Sheet2!$A$2:$A$9, 0),MATCH($J$8,Sheet2!$C$1:$G$1,0))
for A and:
=OFFSET(INDEX(Sheet2!$C$2:$G$9,MATCH(I9,Sheet2!$A$ 2:$A$9,0),MATCH($J$8,Sheet2!$C$1:$G$1,0)),1,0)
for B

HTH
JG



"mik_da_man" wrote:


ng??

I thought i uploaded a zip file fine?

Anyway here is my problem

Sheet2 =


Jan Feb Mar Apr May


Belgium A 0.46 0.57 0.33 0.81 0.46
B 0.85 0.48 0.30 0.94 0.78

PortugalA 0.35 0.33 0.25 0.47 0.83
B 0.93 0.58 0.85 0.96 0.41

France A 0.84 0.32 0.28 0.72 0.63
B 0.67 0.12 0.27 0.24 0.51



Sheet 1 =

Drop down list of months


A B Total
Belgium 0
Portugal 0
France 0
Germany 0
Ireland 0


Kinda hard to expalin without an attachment


--
mik_da_man
------------------------------------------------------------------------
mik_da_man's Profile: http://www.excelforum.com/member.php...o&userid=31067
View this thread: http://www.excelforum.com/showthread...hreadid=507430