If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Coordinates
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) |
#2
|
|||
|
|||
Coordinates
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) |
#3
|
|||
|
|||
Coordinates
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) |
#4
|
|||
|
|||
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) |
Thread Tools | |
Display Modes | |
|
|