when word is typed in cell, how can the row auto displays data?

K

KT

I have created a column of drop down cells in "A." When a value for "A" is
chosen, I would like the rest of the row automatically display the associated
data. How can I accomplish this?
 
B

Bob Phillips

Assuming the associated data is in a lookup table, say A1:H100 on Sheet2,
use

=VLOOKUP(A2,Sheet2!$A$1:$H$100,2,False)

and then repeat with offsets of 3,4, ... etc.
 
K

KT

I am afraid you are talking over my head. Let me be more exact.

Sheet 1 is where I am entering data, Column A consists of a list of foods.
Columns B through I give their various food values.

On Sheet 2, when I am choosing a food from the dropdown list in column A, I
would like the values for columns B through I to automatically enter into the
appropriate cells.

How do I make this happen? (In layman's terms)
 
B

Bob Phillips

As I said, with adjusted reference points, in B2 enter

=VLOOKUP(A2,Sheet1!$A$1:$I$100,COLUMN(),False)

and copy across to column I
 
Top