Condicional concatenation using values on separate sheets

Hi all!
I have been doing some research but can't figure this one out. I must say I'm an excel average user and know just the basics.

The scenario is as follows:
I have two sheets within the same excel file, let's call them A and B.
In sheet A, I have colums 1, 2 and 3 .
Column 1 has a fixed text that can be "D", "M" or "N"
Column 2 has a drop down with options "G" and "B".

These initials would stand for, day, morning, night, good and bad, and I have assigned this in sheet B.

Now, is there a way to use the concatenate function (or any other that may be suitable) in order to concatenate words in colum 3 according to the values in 1 and 2?
i.e.
D, G --> column 3 should say "DayGood".
M, B --> column 3 should say "MorningBad"

I hope it makes sense to someone!
Thanks in advance!
Jon.

Perhaps...
=IF(OR(A1="",B1=""),"",CHOOSE(MATCH(A1,{"D","M","N"},0),"Day","Morning","Night")&CHOOSE(MATCH(B1,{"G","B"},0),"Good","Bad"))

Beau Nydal

Hi Guys,

Thanks a lot, that worked lilke a charm. One additional question now:

When using this conditional formating, if the condition refers to a string:
if (cellX="winner",good,bad)

How can I get the "good" output, for any word in cellX starting with "win" and not only for the word "winner"?

Thanks a lot again!

One way would be to replace cellx="winner" with ISNUMBER(SEARCH("win",cellX))

Beau Nydal