Reply to thread

Message: [QUOTE="Code Numpty, post: 3857760"] Using Excel 2003: I have a complicated quote template in Excel that does everything I need at present. This has grown from simple beginnings and I think may now have gone beyond the capabilities of Excel but the bosses want to stick with Excel. My problem now is nested If formulas. I currently have the following formula to look up a price against a part number in one of 5 separate price list files. --------------------------------------------------------------- =IF(ISBLANK(B26)=TRUE,"",IF(which_price=2,ROUNDUP(VLOOKUP(B26,'\\???srv\shared\Price_Lists\[Export_Prices_Sterling.xls]Prices'!$A:$C,3,FALSE),2),IF(which_price=5,ROUNDUP(VLOOKUP(B26,'\\???srv\shared\Price_Lists\[UK+Ire_Prices_Sterling.xls]Prices'!$A:$C,3,FALSE),2),IF(which_price=1,ROUNDUP(VLOOKUP(B26,'\\???srv\shared\Price_Lists\[Export_Prices_Euros.xls]Prices'!$A:$C,3,FALSE),2),IF(which_price=4,ROUNDUP(VLOOKUP(B26,'\\???srv\shared\Price_Lists\[UK+Ire_Prices_Euros.xls]Prices'!$A:$C,3,FALSE),2),IF(which_price=3,ROUNDUP(VLOOKUP(B26,'\\???srv\shared\Price_Lists\[Export_Prices_US_Dollars.xls]Prices'!$A:$C,3,FALSE),2),)))))) --------------------------------------------------------------- The bosses now want to have more price lists (up to 10!) which means I have exhausted the nested IF formula possibilities and I don't seem to be able to use named formulas as the formula entry box truncates after too few characters entered. Am I going beyond the possibilities of Excel or can anyone suggest a way to tackle this before I spend hours and hours going round in circles? [/QUOTE]

Verification