Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DropDown aand Auto Fill | Excel Discussion (Misc queries) | |||
DropDown aand Auto Fill | Excel Discussion (Misc queries) | |||
DropDown aand Auto Fill | Excel Discussion (Misc queries) | |||
Associating a fill color with a cell value | Excel Discussion (Misc queries) | |||
auto fill or auto search from a list or drop-down list??????? | Excel Discussion (Misc queries) |