 Forums »  List all forums » »  Forum: Tips & Tricks, Questions & Answers » » »  Thread: The Shop Tool » » » »  Post: Re: The Shop Tool Print at May 31, 2020 11:27:07 PM

 Posted by Biliter01 at Feb 27, 2008 5:30:16 PM Re: The Shop Tool I found the error. It is the way the formula looks for a single variable in a whole array of values based on columns (width) and rows (heigth). Apparently the number of columns "width" was short so it wasn't lookin in the right place. Every item that asks for Fine cloth1 and/or Fine cloth2 variables is booched.A fix. For every formula in the "Charged Price" column that includes Fine cloth make this change:+(IF(BR329>BT327,(VLOOKUP(VLOOKUP(AG144,\$Q\$58:\$X\$94,8,0),\$N\$58:\$V\$93,8,FALSE)),
VLOOKUP(VLOOKUP(AG144,\$Q\$58:\$X\$94,8,0),\$M\$59:\$V\$94,8,FALSE))*(BR327+BT327))+N("Primary Cloth"),0)to:+(IF(BR329>BT327,(VLOOKUP(VLOOKUP(AG144,\$Q\$58:\$X\$94,8,0),\$N\$58:\$V\$93,8,FALSE)),
VLOOKUP(VLOOKUP(AG144,\$Q\$58:\$X\$94,8,0),\$M\$59:\$V\$94,9,FALSE))*(BR327+BT327))+N("Primary Cloth"),0)and+(IF(BR329>BT329,(VLOOKUP(VLOOKUP(AG146,\$Q\$58:\$X\$94,8,0),\$N\$58:\$V\$93,8,FALSE)),
VLOOKUP(VLOOKUP(AG146,\$Q\$58:\$X\$94,8,0),\$M\$59:\$V\$94,8,FALSE))*(BR329+BT329))+N("Primary Cloth")+(IF(BS329>BU329,(VLOOKUP(VLOOKUP(AH146,\$Q\$58:\$X\$94,8,0),\$N\$58:\$V\$93,8,FALSE)),
VLOOKUP(VLOOKUP(AH146,\$Q\$58:\$X\$94,8,0),\$M\$59:\$V\$94,8,FALSE))*(BS329+BU329))+N("Secondary Cloth"),0)to:+(IF(BR329>BT329,(VLOOKUP(VLOOKUP(AG146,\$Q\$58:\$X\$94,8,0),\$N\$58:\$V\$93,8,FALSE)),
VLOOKUP(VLOOKUP(AG146,\$Q\$58:\$X\$94,8,0),\$M\$59:\$V\$94,9,FALSE))*(BR329+BT329))+N("Primary Cloth")+(IF(BS329>BU329,(VLOOKUP(VLOOKUP(AH146,\$Q\$58:\$X\$94,8,0),\$N\$58:\$V\$93,8,FALSE)),
VLOOKUP(VLOOKUP(AH146,\$Q\$58:\$X\$94,8,0),\$M\$59:\$V\$94,9,FALSE))*(BS329+BU329))+N("Secondary Cloth"),0)
This should apply to both furnisher and tailor sheets. Pay little attention to everything else in the formulas and just change that single digit and ye should be ok. If you would like to wait about a week I will have a revision ready but I'm sure most of you have established pages. ---------------------------------------- Haywoodx on Viridian and HunterNo CrewNo FlagNo Money:PThe Shop Tool