A couple of days ago I asked this question and the reply I received I did not
under stand. The response was create new lists for each customer and use the
indirect function and this would solve my dilema. I hate to be so thick
headed on this, but I do not understand this function. Could an example be
shown to help me? Here is the question again:
D7 has a dropdown list with customer names (10 -12 customers). F16 thru F38
each have a dropdown list with a vlookup of a products list. Infomation in
columns H thru L are dependent on the product that is shown in cells F16 thru
F38 for unit size, price and extended price. The dilema is that all of the
customers do not have the same pricing. How can I make the cells in F-16
thru F-38 reflect the product and all the associated pricing info for which
ever customer I select from the dropdown list? Can it be done? Pete