Reference multiple cells

[CS1]

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

[Pat Stanford]

I understand what you are trying to do and I don't think you are going to be able to do it in a worksheet in VW2008.

There is no equivalent to the Excel Lookup function in a WS.

Pat