drop down menue and autofills
 

I know how to create a drop down menu, but I want to be able to choose an
item on the drop down list and it will automatically fill in three adjacent
cells with three values that are on another table. How do i do this? I am
using Excel 2007

drop down menue and autofills
 

Hi

Assume your table is in the range H1:M100 and the drop down is in cell A1

then in B1 enter the following formula
=VLOOKUP($A1,$H$1:$M$100,2,FALSE)
this will check H1:H100 for the item in A1 and return an item from the
second (2) column of the lookup table when it finds an exact match with A1 in
column H.

A modified version of this would be put in C1 and D1, the only difference
being the "2".

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"leslie" wrote:

I know how to create a drop down menu, but I want to be able to choose an
item on the drop down list and it will automatically fill in three adjacent
cells with three values that are on another table. How do i do this? I am
using Excel 2007

drop down menue and autofills
 

Hi,

You can use Vlookup function here, to link two different tables and to get
the output



Deepali Joshi

"leslie" wrote:

I know how to create a drop down menu, but I want to be able to choose an
item on the drop down list and it will automatically fill in three adjacent
cells with three values that are on another table. How do i do this? I am
using Excel 2007

drop down menue and autofills
 

Hi Shane

Your help got me part way there, but.....
My drop down list is in in cell D23 (12 items). I want to fill in values
D24-D27 based on my selection in D23. I have a table with 12 rows. D219-D230
is my drop down list, E219-E230 is column 1 to fill in D24, F219-F230 is
column 2 to fill in D25, G219-G230 is column 3 to fill in D26, H219-H230 is
column 4 to fill in D27. The formula you provided works great for the first
item in the drop down. However when I change the item on the drop down, it
can't change the coresponding list. Any ideas?

Leslie

"Shane Devenshire" wrote:

Hi

Assume your table is in the range H1:M100 and the drop down is in cell A1

then in B1 enter the following formula
=VLOOKUP($A1,$H$1:$M$100,2,FALSE)
this will check H1:H100 for the item in A1 and return an item from the
second (2) column of the lookup table when it finds an exact match with A1 in
column H.

A modified version of this would be put in C1 and D1, the only difference
being the "2".

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"leslie" wrote:

I know how to create a drop down menu, but I want to be able to choose an
item on the drop down list and it will automatically fill in three adjacent
cells with three values that are on another table. How do i do this? I am
using Excel 2007

drop down menue and autofills
 

Never Mind Deepali and Shane
I got it to work...

Thanks so much.

leslie
"leslie" wrote:

Hi Shane

Your help got me part way there, but.....
My drop down list is in in cell D23 (12 items). I want to fill in values
D24-D27 based on my selection in D23. I have a table with 12 rows. D219-D230
is my drop down list, E219-E230 is column 1 to fill in D24, F219-F230 is
column 2 to fill in D25, G219-G230 is column 3 to fill in D26, H219-H230 is
column 4 to fill in D27. The formula you provided works great for the first
item in the drop down. However when I change the item on the drop down, it
can't change the coresponding list. Any ideas?

Leslie

"Shane Devenshire" wrote:

Hi

Assume your table is in the range H1:M100 and the drop down is in cell A1

then in B1 enter the following formula
=VLOOKUP($A1,$H$1:$M$100,2,FALSE)
this will check H1:H100 for the item in A1 and return an item from the
second (2) column of the lookup table when it finds an exact match with A1 in
column H.

A modified version of this would be put in C1 and D1, the only difference
being the "2".

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"leslie" wrote:

I know how to create a drop down menu, but I want to be able to choose an
item on the drop down list and it will automatically fill in three adjacent
cells with three values that are on another table. How do i do this? I am
using Excel 2007