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.
Bookmarks