Hi Please help
I trying to create an estimating system for a product. The price varies by size, so I've created an array which can be looked up. It works fine until I go beyond 7.
The formula is as follows : if (C10="Product_B",vlookup(Value,Array,column,0),if(C10="Product_C",vlookup(Value,array,column,0), etc
However once I get beyond 7 arguments I get an error message of too many arguments. I am using 2003. What is the fix please ( with an example)
thanks
Nick
Bookmarks