Is there anyway I can set up a system where if I type a variable ( alpha
numeric/numeric) in say d1, it will automatically put strings assigned to
this variable in D2, D3
e.g variable P1234

D1 D2 D3 D4
P1234 op1 op2 op3 etc

VLOOKUP table and formulas should do the trick.

See help on VLOOKUP

I note you have your D1, D2, D3 and D4 horizontally displayed when they
should be vertically oriented.

Is that a typo or did you mean D1, E1, F1 and G1?


Gord Dibben MS Excel MVP


On Mon, 26 Oct 2009 11:21:01 -0700, Ferdy
wrote:

Is there anyway I can set up a system where if I type a variable ( alpha
numeric/numeric) in say d1, it will automatically put strings assigned to
this variable in D2, D3
e.g variable P1234

D1 D2 D3 D4
P1234 op1 op2 op3 etc