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) |
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) |
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) |
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) |
All times are GMT +1. The time now is 11:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com