Show a word depending in a different column

[luke.guthrie]

I need a code that will display the word "April" in Y if AH = "1". It cannot be a formula.

Thanks.

[Thalassa]

It cannot be a formula.

Thanks.

Why not?

=CHOOSE(AH1,"April","May","June","July","August","September","October","November","December","January","February","March")

[luke.guthrie]

Because I am uploading the file to an external site and it won't accept anything that isn't hard coded.

[tom1977]

Hi If I understood You check this

Please Login or Register  to view this content.

[luke.guthrie]

That didn't return anything. Here is the code I am trying to add it to, maybe it has something to do with that.

[StevenM]

This macro will put "April" in column Y every time column "AH" equals 1.

Please Login or Register  to view this content.

[Thalassa]

Perhaps

Please Login or Register  to view this content.

[luke.guthrie]

That is not returning anything, either.

[luke.guthrie]

Perhaps

Please Login or Register  to view this content.

This is just returning #VALUE in the cell

[Thalassa]

It works perfectly here.

[luke.guthrie]

My number format is "00" in AH, does that have something to do with it?

[Thalassa]

Works fine for me with that number format. Are your numbers numbers or numbers stored as text (if they are numbers they should be right justified in the cell).

[luke.guthrie]

Left justified so stored as text. They are generated by this code.

[Thalassa]

Try

Please Login or Register  to view this content.

[luke.guthrie]

Perfect thanks!