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

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?

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.

--
HTH

Bob Phillips

"KT" wrote in message
...
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?

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)
"Bob Phillips" wrote:

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.

--
HTH

Bob Phillips

"KT" wrote in message
...
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?

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


--
HTH

Bob Phillips

"KT" wrote in message
...
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)
"Bob Phillips" wrote:

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.

--
HTH

Bob Phillips

"KT" wrote in message
...
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?