How do I match a MM to a MM/YY & then Match then assign a value.

[dooredge]

Hi,

I need write a forumla to solve the following (please see attached picture):

excel2012_forumla.jpg


Stating the obvious here:
Column B = M/D/Y formatted show show as M/Y
Column C = numerical value


I would like to write a forumla in each cell E3:P3 that will match the generic month (JAN/FEB/MAR etc) to the M/Y corresponding numerical value.

E3 would solve to 560
F3 would solve to 499
G3 would solve to 351

So on and so forth...


Thanks,
Jerod



EDIT: Sorry for the horrible subject line.

[Ace_XL]

In E3 use

=INDEX($C$2:$C$13,MATCH(E2,TEXT($B$2:$B$13,"mmm"),0))

Confirm with Ctrl+Shift+Enter and not just Enter and copy across

[dooredge]

Excellent, thank you so much Ace_XL.


Jerod

[dooredge]

See here: http://www.excelforum.com/excel-form...-fuctions.html


apologies for the double-post. I should have started a new thread in the beginning.