Using INDEX to lookup multiple values in a list

[skmerrey]

Hi Everyone,

I'm having trouble adapting my formula to look at months instead of a specific data. I am using the INDEX and SMALL function to return Values from a list that have the date I specify. I now need to adapt the formula to look at the month and return the values.

I have attached a sample sheet. My actual tables are much bigger but this is the basic function I need.

Any help or thoughts would be much appreciated.

Thanks
Shaun

 

[NARAYANK991]

Hi Shaun ,

Try this array formula , to be entered using CTRL SHIFT ENTER :

=INDEX($A$2:$A$13,SMALL(IF(TEXT($B$2:$B$13,"mmm")=$D$15,ROW($B$2:$B$13) - MIN(ROW($B$2:$B$13)) + 1),ROW(1:1)))

Narayan

 

[bosco_yip]

Another option :

=INDEX(A:A,SMALL(IF(TEXT(B$2:B$13,"mmm")=D$15,ROW(B$2:B$13),4^8),ROW(1:1)))&""

Confirm entered with SHIFT+CTRL+ENTER.

Regards
Bosco

 

[skmerrey]

Hi Guy's,
Thanks, they both work perfectly.
Thanks alot for your help.
shaun