Is there a way to create an equation so that when using the IF command a cell to the right of the active cell is shown also.
In other words if I have the following information in my cells
A1: 10
A2: 20
A3: 30
A4: 40
A5: 50
B1: example one
B2: example two
B3: example three
B4: example four
B5: example five
In cell E1 can I have an equation which does the following
If C1 = '20' then show the value of the cell to the right of A2 (which is B2 "example one") in cell D1
So in cell C1 if I enter '10' the text 'example one' will show in D1.
So in cell C1 if I enter '20' the text 'example two' will show in D1.
So in cell C1 if I enter '30' the text 'example three' will show in D1.
etc etc etc
I know i can create this by using something like the following in D1
=IF((C1=A1),B1,IF((C1=A2),B2,IF((C1=A3),B3,IF((C1=A4),B4,IF((C1=A5),B5,'))))
This does what i need the only downside is I can't just click on the cell B2 and change the text from "example two" to "test two" and have it change in the equation in D1, I have to manually change it in the equation line.
I hope someone can understand what I have just tried to explain