Associating data for auto fill in from dropdown list
 

I have a large dropdown list and each item in the
dropdown list has assocated data in row formate. i want
to be able to choose an item in the dropdown list and
then have the assocated data automatically fill in. Is
this possible?

Associating data for auto fill in from dropdown list
 

you can have formulas in the cell that refer to the cell in the dropdown
list. (assume the dropdown is in A1 on the sheet where the formula will be
entered).


=Vlookup(A1,Sheet3!$A$1:$F$50,2,False)

would return the information in column B of Sheet3 for the row that has a
value in column A that matches the value in A1 of the sheet with the
formula. If the lookup values are not on the left side of the range, you
can use a combination of index and match

=Index(Sheet3!$B$1:$B$50,match(A1,Sheet3!$D$1:$D$5 0,0),1)

This would find the value in column D and return the corresponding value in
B.

Associating data for auto fill in from dropdown list
 

Thanks Tom, your information was a big help.
-----Original Message-----
you can have formulas in the cell that refer to the cell
in the dropdown
list. (assume the dropdown is in A1 on the sheet where
the formula will be
entered).


=Vlookup(A1,Sheet3!$A$1:$F$50,2,False)

would return the information in column B of Sheet3 for
the row that has a
value in column A that matches the value in A1 of the
sheet with the
formula. If the lookup values are not on the left side
of the range, you
can use a combination of index and match

=Index(Sheet3!$B$1:$B$50,match(A1,Sheet3!$D$1:$D$ 50,0),1)

This would find the value in column D and return the
corresponding value in
B.

--
Regards,
Tom Ogilvy

"Mike Dooley"
wrote in message
...
I have a large dropdown list and each item in the
dropdown list has assocated data in row formate. i
want
to be able to choose an item in the dropdown list and
then have the assocated data automatically fill in. Is
this possible?


.