Coordinates

[5F80YZ]

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)

 

[Jacob Skaria]

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

 

[Rick Rothstein]

Here is a slightly shorter alternative formula which uses one less function
call...

=VLOOKUP(A6,A1:E4,MATCH(B6,A1:E1,0),FALSE)

 

[5F80YZ]

Thanks heaps guys!!

I decided to go with Rick formula as it was simplier and shorter.

Thanks for the prompt reply!!