Would someone mind looking at the attached spreadsheet and telling me where I’m going wrong? I’ve spent WAY too much time trying to figure the problem out today and I still don’t have the answer. This is a sales order spreadsheet. The relevant inputs are 1) pricing level (AR2), 2) quantity, 3) unit of order (cases or pallets) and 4) and product (one of four choices based on package size and labels). The formula I’m having problems with is in the Unit Price column. It uses some tables on the Pricing Table tab to determine the proper unit price which is then multiplied by the quantity to determine the total price for the line item. Everything seems to work fine for the first three selections from the drop down menu in the pricing level box. However, when I choose the fourth option (12 pallets), the Unit Price formula returns #N/A, which apparently means it can’t locate that value in the lookup table. However, I have verified that the value is indeed there. What am I missing? I protected the worksheet without a password in case you need to look at any of the locked cells. Many thanks.
Phil
