Associating data for auto fill in from dropdown list

[Mike Dooley]

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?

 

[Tom Ogilvy]

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.

 

[Mike Dooley]

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




.