You're welcome.....I'm glad that helped.

Regards,

Ron
Microsoft MVP (Excel)

"Ruth" wrote in message
...
Ron that worked like a charm! Thanks :)

"Ron Coderre" wrote:

See Debra Dalgleish's website....she has a great
Order Form example and instructions:
http://www.contextures.com/xlOrderForm01.html

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Ruth" wrote in message
...
I have a worksheet that is making me crazy. Basically its a sales order
form
with drop down menus for each set of items based on category. I want
the
MSRP
field to autofill with the prices when an item is selected and for this
I
am
using the "if" with nesting. But it only allows me to nest 8 and I need
14.

Any suggestions on other functions I can use to accomplish this?