Coordinates
Thanks heaps guys!!
I decided to go with Rick formula as it was simplier and shorter.
Thanks for the prompt reply!!
"Rick Rothstein" wrote:
Here is a slightly shorter alternative formula which uses one less function
call...
=VLOOKUP(A6,A1:E4,MATCH(B6,A1:E1,0),FALSE)
--
Rick (MVP - Excel)
"Jacob Skaria" wrote in message
...
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)
|