Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup updates
I am trying to vlookup data in column X based on a particular month eg
December. Is that possible? Month x Data Mar-06 1 100 Apr-06 2 51 May-06 3 497 Jun-06 4 494 Jul-06 5 0 Aug-06 6 10 Sep-06 7 197 Oct-06 8 495 Nov-06 9 700 Dec-06 10 747 Jan-07 11 660 Feb-07 12 542 -- sarah |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup updates
Hi!
Try this: A1 = Lookup_value = December Formula needs to be array entered using the key combo of CTRL,SHIFT,ENTER: =INDEX(C2:C13,MATCH(A1,TEXT(A2:A13,"mmmm"),0)) Biff "sarah" wrote in message ... I am trying to vlookup data in column X based on a particular month eg December. Is that possible? Month x Data Mar-06 1 100 Apr-06 2 51 May-06 3 497 Jun-06 4 494 Jul-06 5 0 Aug-06 6 10 Sep-06 7 197 Oct-06 8 495 Nov-06 9 700 Dec-06 10 747 Jan-07 11 660 Feb-07 12 542 -- sarah |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup updates
Here's another way as long as there is only one entry per month (as in your
posted example): Normally entered: A1 = December =SUMPRODUCT(--(TEXT(A2:A13,"mmmm")=A1),C2:C13) Biff "Biff" wrote in message ... Hi! Try this: A1 = Lookup_value = December Formula needs to be array entered using the key combo of CTRL,SHIFT,ENTER: =INDEX(C2:C13,MATCH(A1,TEXT(A2:A13,"mmmm"),0)) Biff "sarah" wrote in message ... I am trying to vlookup data in column X based on a particular month eg December. Is that possible? Month x Data Mar-06 1 100 Apr-06 2 51 May-06 3 497 Jun-06 4 494 Jul-06 5 0 Aug-06 6 10 Sep-06 7 197 Oct-06 8 495 Nov-06 9 700 Dec-06 10 747 Jan-07 11 660 Feb-07 12 542 -- sarah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Excel won't launch after applying MS Office Updates | Excel Discussion (Misc queries) | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |