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!

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

<tbody>
</tbody>

 

[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