Linda

If I understand you correctly this site should give you direction if not the
answer.

http://www.contextures.com/xlDataVal02.html

Mike Rogers

"Linda" wrote:

I need to creat a estimate form. A1 cell with dropdown list for model and B1
cell with dropdown list for different size. How I can get the price at C1
when I select one of the model then select one of the size?
such as:
Model: M1, M2, M3, M4
Size: 10', 15', 20'
Price:M1 with 10' is $100, M1 with 15' is $120, M1 with 20' is $140
M2 with 10' is $110, M2 with 15' is $130 ...etc.
When I selected M1 for model at A1 and selected 15' for size at B1, C1
should shows price $120.
When I selected M2 for model at A1 and selected 10' for size at B1, C1
should shows price $110.

If I can get help for this problem, I would really appreciate.

Thanks!

Linda