Too many arguments

[NickTY]

Hello

I'm creating a quoting system based on the A) the type of door and B) the size of door. I set and array for each door and the sizes available and the sales Price. I'm using IF the door is the style, then look at that particular array for its size and return the selling price:

The formula is

if(d10="ProductA",vlookup(d12,"ProductA!"$a$1:$d$44,4,0),if(d10="ProductB",vlookup(d12,"ProductB!$A$1:$d$44,4,0), if( etc, etc

However , once beyond 7 products I get error message " Too many arguments" Im using 2003
is there a fix?

Thanks

 

[Scott Huish]

The value in D10 is the name of your sheet to lookup the value on. As that appears to be the only difference, use INDIRECT instead:

=VLOOKUP(D12,INDIRECT("'"&D10&"'!A1:D44"),4,0)