automatically filling in data for a value manually input

[DocBravo]

How do I get my excel program to look at a value I enter in one cell and
automatically populate up to three other cells with values tied to that which
was input. for example if I enter "8076" in cell A1 the program will look at
a group of pre-entered values and match that number to three related values
and then populate them in the matching cells. Such as the example below:

if A1= "8076" then C1 = Stevens, D1 = 13, F1 = $1.44, and H1 = D1*F1

Where "Stevens, 13, and $1.44" are all pre-entered values that match the
input "8076"

 

[vanderghast]

In Access you would fill the data in another table, one row by 'id':

a1 c1 d1 f1
8076 stevens 13 1.44
8088 mary 11 1.55


and use an update query based on a join ON the key value of that said
table:


UPDATE table2 INNER JOIN tableWithNewValues As n
ON table2.a1 = n.a1
SET table2.c1=n.c1,
table2.d1=n.d1,
table2.f1=n.f1,
table2.h1=n.d1*n.f1




Vanderghast, Access MVP