Variable results from a cell input

[Blakes7]

Hi,

Not sure how to do this but I want to have a cell display various message text depending the value input into another cell

e.g. if value in cell D10 = 1 then in cell D8 I want to see the message Change
if value in cell D10 = 2 then in cell D8 I want to see the message Pump Out

I may want to expand this for several more different messages. Can this be done?

 

[jmacleary]

You can do this with a VLOOKUP. In another area of your workshhet, type the value in one column (I have assumed G) and the result you want in the column to the right (H). Then use this formula in D8: =VLOOKUP(D10,G:H,2,false)
You can then just add further entries in columns G and H as needed.

Excel 2007 32 bit

	D	E	F	G	H	I
Text for value 1
Text for value 2
etc.
Text for value 1

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]2[/TD]

[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]3[/TD]

[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH]D10[/TH]
[TD="align: left"]=VLOOKUP(D8,G:H,2,FALSE)
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[sparky2205]

You could also use:
=CHOOSE(D10,"Change","Pump Out")
Just add more options into the formula as required.

 

[Blakes7]

Hi,

Works great on a blank sheet but having problem on the actual sheet, I may be getting confused on the actual sheet I want the text to be displayed in cell G8 based on the value I input into cell J8 I also want to copy the formula to other cells in the same columns and display text from a set of text which will be fixed into cells in column L so the formula will have to take into account the values in he cells in column being absolute values for all the cells the formulae are inserted.

 

[sparky2205]

I don't completely understand what you're looking for.
Maybe if you posted an example here. I know you can't attach a file but give some specific examples of your text, where it is positioned and what the expected result is.
It may be as simple as changing =CHOOSE(D10,"Change","Pump Out") to =CHOOSE(D10,L1,L2,L3) but I can't be sure without examples.

 

[Blakes7]

Mnaged to figure it out