| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| GPS Coordinates | Excel Discussion (Misc queries) | |||
| coordinates | Charts and Charting in Excel | |||
| Are These Coordinates? | Charts and Charting in Excel | |||
| map coordinates | Charts and Charting in Excel | |||
| Triangular Coordinates | Charts and Charting in Excel | |||
Linear Mode
