I'm trying to make some sort of spreadsheet for easier note taking (basically a generator of sorts) and I'm having difficulty in trying to find the right way to go at it. I'm basically a total noob at this and just literally started tinkering with Excel and just successfully finished my first IF formula (A little sad, I know, but I'm happy about the progress I've made).
Basically, what I want to do is try to add text from a different cell that would appear before the IF formula.
This is an example of what I have right now: Cells A1-5 are different animals: Cat, Dog, Fish, Moose
I created a drop list in B1
In C1 I have the IF formula so that whatever is selected in B1 it would appear as such in C1.
What I want to accomplish here is I want to add text that would be taken from different cells so that it would appear before the data in C1.
Like in D1 I would have "It's" and in E1 I would have "A".
What I want to do is that everything I select from the list of animals it would appear as "It's a Cat" "It's a Dog" and so on and so forth in C1. But the thing is I can't find a way to have it done as I want to be able to change the data in D1 and E1 so that it would reflect each time I choose a different animal (I'm sorry if I'm using animals, it was the easiest thing I could think of when practicing the IF formula).
I don't know if what I'm asking is too much, but I'd really like any info regarding this.