Greetings,

We are trying to create a simple Excel form that a field engineer could use.
We're having trouble with two concepts...

In one section we'd like him to choose from 2 options, "a" or "b". If he
chooses "a", then it would pull a price from cell A1. if he chooses option
"b", it will choose the price from cell B1.

In a second section, we'd like him to choose 1 option from about 10
possibilities. I assume that will be very similar to the first section.

Can someone teach me how to create a simple form with the 2 choices, then
pull from a different cell depending on which choice is made?

Thanks for your help!!!

Cheers,

Scot B.