Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup from lists
I have a main drop down box(A) with several options, then in the next box I
have another drop down box(B) listing component defined by the previous box. I would like to now relate a price found within the list. The price is in the list described by box (A) and next to the component described by box (B) needs to be put into a different worksheet. Is this possible? Any help/ideas greatfully recieved Andy |
#2
|
|||
|
|||
I am not clear on the detail, but the ListIndex property will relate to the
item selected in DD A, so you can then get the list value from B using the same listindex value, something like, but not exactly Worksheets("Sheet2").Range("A1").Value = ListboxB.List(ListboxA.ListIndex) all depending upon where your listboxes reside. If it is a Data Validation dropdown, it is trickier, but you would need to MATCH the item in A against its source list to find the index, then do similar to B's source list. -- HTH Bob Phillips "Vlookup from lists" <Vlookup from wrote in message ... I have a main drop down box(A) with several options, then in the next box I have another drop down box(B) listing component defined by the previous box. I would like to now relate a price found within the list. The price is in the list described by box (A) and next to the component described by box (B) needs to be put into a different worksheet. Is this possible? Any help/ideas greatfully recieved Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Vlookup - Comparing two lists in different worksheets | Excel Worksheet Functions | |||
Vlookup | Excel Worksheet Functions | |||
Problem with VLOOKUP and drop-down lists! | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |