Nesting function or other suggestions
 

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?

Nesting function or other suggestions
 

Make a small table of item in one column and price in the column next to it.
Then use =VLOOKUP() to get the price once an item is selected.
--
Gary''s Student - gsnu200777


"Ruth" wrote:

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?

Nesting function or other suggestions
 

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?

Nesting function or other suggestions
 

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?

Nesting function or other suggestions
 

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?

Nesting function or other suggestions
 

Hi Ruth,

Excel 2003 and earlier allows 7 levels of nesting. Excel 2007 allows 64
levels.

You can beat the 2003 limit by 1. Employing range names for portions of the
formulas, 2. Concatenation formula components, 3. Creating the formulas in
Lotus 1-2-3 or Quattro Pro and then import the file.

In my experience deep nesting is often the result of using an inefficient
approach to solving a problem - for example using a nested IF when one
should use a VLOOKUP.

Without seeing an example of your formula we will be limited on how we can
help.

Cheers,
Shane Devenshire
Microsoft Excel MVP

"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?