Month vs Sequence Number Formula

[The_Game]

I've set up a CONCATENATE formula to read several cells to give me my final output, trouble is: I can't seem to associate a FY month with a 001-012 number, and have it report as text. I need a formula for my final cell: IF(MONTH(TODAY())...followed by a VLOOKUP for the month on this table, then reference the number next to it. I'm having trouble writing this formula, but think this is the way to reference the sequence number I need. Can I get some help filling in the blanks? Thank you!

[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Seq#[/TD]
[TD][/TD]
[TD]=CONCATENATE(B25,C25,D25,E25,F25,G25)[/TD]
[/TR]
[TR]
[TD]October[/TD]
[TD]001[/TD]
[TD][/TD]
[TD]G25=[Formula to reference table][/TD]
[/TR]
[TR]
[TD]November[/TD]
[TD]002[/TD]
[TD][/TD]
[TD]The cell above will be the one[/TD]
[/TR]
[TR]
[TD]December[/TD]
[TD]003[/TD]
[TD][/TD]
[TD]the CONCATENATE formula [/TD]
[/TR]
[TR]
[TD]January[/TD]
[TD]004[/TD]
[TD][/TD]
[TD]addresses[/TD]
[/TR]
[TR]
[TD]February[/TD]
[TD]005[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]March[/TD]
[TD]006[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]April[/TD]
[TD]007[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]May[/TD]
[TD]008[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]June[/TD]
[TD]009[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD]010[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]August[/TD]
[TD]011[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]September[/TD]
[TD]012[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

I'm not quite sure I get what you want, but maybe:

=VLOOKUP(TEXT(TODAY(),"mmmm"),$A$2:$B$13,2,FALSE)

where the range in red is your table?

 

[Tetra201]

... I can't seem to associate a FY month with a 001-012 number, and have it report as text.

Here is how to do it -- assuming you have the date, which you want to convert into Seq#, in cell A1:

=TEXT(MONTH(A1)+3-INT(MONTH(A1)/10)*12,"000")

 

[The_Game]

Here is how to do it -- assuming you have the date, which you want to convert into Seq#, in cell A1:

=TEXT(MONTH(A1)+3-INT(MONTH(A1)/10)*12,"000")

Although I'm not familiar with the "INT" portion of this formula...This worked perfectly!! Thank you so much!

 

[Tetra201]

You are welcome.

INT rounds a number down to the nearest integer: =INT(11/10) returns 1; =INT(5/10) returns 0