Try the below

Col A Col B Col C Col D Col E
Country\Date 9-Jan 9-Feb 9-Mar 9-Apr
EUR 10 20 50 90
AUS 5 25 98 10
CAN 1 56 10 32

AUS 9-Feb =INDEX(A1:E4,MATCH(A6,A1:A4,0),MATCH(B6,A1:E1,0))

Formula in C6 with 'AUS' in A6 and query date in B6

If this post helps click Yes
---------------
Jacob Skaria


"5F80YZ" wrote:

Greetings,

I need help with the following

Country\Date Jan09 Feb09 Mar09 Apr09
EUR 10 20 50 90
AUS 5 25 98 10
CAN 1 56 10 32

What formula do I use to look up for the value of a country and the date??
(eg. value of AUS in Feb09)