Formula for adding Text and Month in one cell

[Erios]

I have about 6 different columns with info. One column is account numbers, the other is Description, date, amount, year, term.
I want my Description column to print out "PV Online Housing Payment - "month"
Column D has the account numbers (they area about 6 account numbers)
Column F has the dates

I want Column E to read column D an F and be able to determine what to print out.

this is the formula that I was trying to use buy can't make it work, it has been giving me FALSE instead.

=IF(D5="11000013620000","PV Online Housing Payment "&CHOOSE(MONTH(F5),"- Jan","- Feb","- Mar","- Apr","- May","- Jun","- Jul","- Aug"))

At the same time to able to determine what account number it is and what month to choose and print out "PC Online Housing Payment - (month, what ever month it was done)

[bhenlee]

are you only referring to just one account number?

it would be easier to understand and help you if you could post a sample file.

[Jonmo1]

If it's returning FALSE
That means D5 does NOT = "11000013620000"

Try removing those Quote marks around the account number.


also, here's a much simpler way to get the month name
=TEXT(F5,"mmm")

So you could try
=IF(D5=11000013620000,"PV Online Housing Payment - "&TEXT(F5,"mmm"))

[Erios]

That worked thanks

[Jonmo1]

You're welcome.