software

I am trying to vlookup data in column X based on a particular month eg
December.

Is that possible?

MonthxData
Mar-061100
Apr-06251
May-063497
Jun-064494
Jul-0650
Aug-06610
Sep-067197
Oct-068495
Nov-069700
Dec-0610747
Jan-0711660
Feb-0712542--
sarah

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,quot;mmmmquot;),0))

Biff

quot;sarahquot; gt; wrote in message
...
gt;I am trying to vlookup data in column X based on a particular month eg
gt; December.
gt;
gt; Is that possible?
gt;
gt; Month x Data
gt; Mar-06 1 100
gt; Apr-06 2 51
gt; May-06 3 497
gt; Jun-06 4 494
gt; Jul-06 5 0
gt; Aug-06 6 10
gt; Sep-06 7 197
gt; Oct-06 8 495
gt; Nov-06 9 700
gt; Dec-06 10 747
gt; Jan-07 11 660
gt; Feb-07 12 542
gt;
gt;
gt; --
gt; sarah
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,quot;mmmmquot;)=A1),C2:C13)

Biff

quot;Biffquot; gt; wrote in message
...
gt; Hi!
gt;
gt; Try this:
gt;
gt; A1 = Lookup_value = December
gt;
gt; Formula needs to be array entered using the key combo of CTRL,SHIFT,ENTER:
gt;
gt; =INDEX(C2:C13,MATCH(A1,TEXT(A2:A13,quot;mmmmquot;),0))
gt;
gt; Biff
gt;
gt; quot;sarahquot; gt; wrote in message
gt; ...
gt;gt;I am trying to vlookup data in column X based on a particular month eg
gt;gt; December.
gt;gt;
gt;gt; Is that possible?
gt;gt;
gt;gt; Month x Data
gt;gt; Mar-06 1 100
gt;gt; Apr-06 2 51
gt;gt; May-06 3 497
gt;gt; Jun-06 4 494
gt;gt; Jul-06 5 0
gt;gt; Aug-06 6 10
gt;gt; Sep-06 7 197
gt;gt; Oct-06 8 495
gt;gt; Nov-06 9 700
gt;gt; Dec-06 10 747
gt;gt; Jan-07 11 660
gt;gt; Feb-07 12 542
gt;gt;
gt;gt;
gt;gt; --
gt;gt; sarah
gt;
gt;