Coordinates

  • Thread starter Thread starter 5F80YZ
  • Start date Start date
5

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)
 
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
 
Here is a slightly shorter alternative formula which uses one less function
call...

=VLOOKUP(A6,A1:E4,MATCH(B6,A1:E1,0),FALSE)
 
Thanks heaps guys!!

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

Thanks for the prompt reply!!
 
Back
Top