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