Spreadsheet: 586385d1534349344-using-if-function-for-multiple-look-up-values-ifvalue
Sheet: Sheet1

Product Code | Inventory QTY for 18/19 Holiday Season | Brand | Landed Cost |  | ASC Price | AMZ Fee | ASC Cost Gound | ASC total cost | ASC Ground GM $ | GM % | ASC Cost Smart Post | total cost |  | Smart Post | GM % |  | FBA Price | FBA FEES | FBA Ship cost | estimated ship to FBA | FBA total cost | FBA | Estimated GM % |  | SFP Price | AMZ fees | SFP Shipping Cost | SFP total cost | SFP | GM % |  | [NAME] | [NAME] total Cost |  | Drop Ship | GM % |  | VC Direct Price | VC Direct Cost | VC | GM % |  | [NAME] Cost | UPS Surepost Cost |  | MAX PROFIT | Max Profit Channel | Preferred sales channel | CORP Suggested Price | show total cost here
83-XMS1005 | 9572 | Elf Stor | 3.47 |  | 16.88 | 2.53 | 9.79 | 15.79 | 1.09 | 0.06 | 5.8 | 11.8 |  | 5.08 | 0.3 |  | 16.88 | 2.53 | 5.64 |  | 11.64 | 5.24 | 0.31 |  | 18.88 | 2.83 | 9.79 | 16.09 | 2.79 | 0.15 |  | 9.04 | 7.96 | 0 | 4.49 | 0.56 |  | 9.04 | 7.96 | 4.49 | 0.56 |  | 9.79 | 5.8 |  | 5.24 | FBA | FBA Price | 15.95 | 11.64
83-DT5008 | 4815 | Elf Stor | 3.17 |  | 14.95 | 2.24 | 9.79 | 15.2 | -0.25 | -0.02 | 5.8 | 11.21 |  | 3.74 | 0.25 |  | 14.95 | 2.24 | 5.64 | 0.17 | 11.23 | 3.72 | 0.25 |  | 17.48 | 2.62 | 9.79 | 15.58 | 1.9 | 0.11 |  | 12 | 10.56 | 0 | 7.39 | 0.7 |  | 12 | 10.56 | 7.39 | 0.7 |  | 9.79 | 5.8 |  | 7.39 | Drop Ship | [NAME] | 14.95 | 10.56
83-DT5010 | 2486 | Elf Stor | 3.42 |  | 16.88 | 2.53 | 9.79 | 15.74 | 1.14 | 0.07 | 5.2 | 11.15 |  | 5.73 | 0.34 |  | 16.88 | 2.53 | 5.24 | 0.17 | 11.37 | 5.51 | 0.33 |  | 18.88 | 2.83 | 9.79 | 16.04 | 2.84 | 0.15 |  | 11.5 | 10.12 | 0 | 6.7 | 0.66 |  | 11.5 | 10.12 | 6.7 | 0.66 |  | 9.79 | 5.2 |  | 6.7 | Drop Ship | ASC Price | 15.95 | 16.88
83-DT5011 | 5395 | Elf Stor | 3.17 |  | 14.88 | 2.23 | 9.79 | 15.19 | -0.31 | -0.02 | 5.2 | 10.6 |  | 4.28 | 0.29 |  | 14.88 | 2.23 | 5.67 | 0.14 | 11.21 | 3.67 | 0.25 |  | 19.48 | 2.92 | 9.79 | 15.88 | 3.6 | 0.18 |  | 9.97 | 8.77 | 0 | 5.6 | 0.64 |  | 9.97 | 8.77 | 5.6 | 0.64 |  | 9.79 | 5.2 |  | 5.6 | Drop Ship | SFP Price | 15.95
83-DT5012 | 5143 | Elf Stor | 1.8 |  | 10.99 | 1.65 | 9.79 | 13.24 | -2.25 | -0.2 | 5.2 | 8.65 |  | 2.34 | 0.21 |  | 10.99 | 1.65 | 3.25 | 0.07 | 6.77 | 4.22 | 0.38 |  | 14.95 | 2.24 | 9.79 | 13.83 | 1.12 | 0.07 |  | 7.15 | 6.29 | 0 | 4.49 | 0.71 |  | 7.15 | 6.29 | 4.49 | 0.71 |  | 9.79 | 5.2 |  | 4.49 | Drop Ship | FBA Price | 11.95
83-DT5013 | 1391 | Elf Stor | 2.06 |  | 10.99 | 1.65 | 9.79 | 13.5 | -2.51 | -0.23 | 5.2 | 8.91 |  | 2.08 | 0.19 |  | 10.99 | 1.65 | 3.28 | 0.06 | 7.05 | 3.94 | 0.36 |  | 14.95 | 2.24 | 9.79 | 14.09 | 0.86 | 0.06 |  | 8 | 7.04 | 0 | 4.98 | 0.71 |  | 8 | 7.04 | 4.98 | 0.71 |  | 9.79 | 5.2 |  | 4.98 | Drop Ship | [NAME] | 11.95
83-DT5014 | 7186 | Elf Stor | 3.11 |  | 14.95 | 2.24 | 9.79 | 15.14 | -0.19 | -0.01 | 5.2 | 10.55 |  | 4.4 | 0.29 |  | 14.95 | 2.24 | 5.65 | 0.14 | 11.14 | 3.81 | 0.25 |  | 16.88 | 2.53 | 9.79 | 15.43 | 1.45 | 0.09 |  | 11 | 9.68 | 0 | 6.57 | 0.68 |  | 11 | 9.68 | 6.57 | 0.68 |  | 9.79 | 5.2 |  | 6.57 | Drop Ship | FBA Price | 14.95
83-XMS1016 | 6036 | Elf Stor | 5.29 |  | 19.98 | 3 | 9.79 | 18.08 | 1.9 | 0.1 | 5.8 | 14.09 |  | 5.89 | 0.29 |  | 19.98 | 3 | 6.08 | 0.22 | 14.58 | 5.4 | 0.27 |  | 19.98 | 3 | 9.79 | 18.08 | 1.9 | 0.1 |  | 13.36 | 11.76 | 0 | 6.47 | 0.55 |  | 13.36 | 11.76 | 6.47 | 0.55 |  | 9.79 | 5.8 |  | 6.47 | Drop Ship | ASC Price | 18.95
83-DT5016 | 2197 | Elf Stor | 3.11 |  | 14.95 | 2.24 | 9.79 | 15.14 | -0.19 | -0.01 | 5.8 | 11.15 |  | 3.8 | 0.25 |  | 14.95 | 2.24 | 4.79 | 0.14 | 10.28 | 4.67 | 0.31 |  | 16.88 | 2.53 | 9.79 | 15.43 | 1.45 | 0.09 |  | 11 | 9.68 | 0 | 6.57 | 0.68 |  | 11 | 9.68 | 6.57 | 0.68 |  | 9.79 | 5.8 |  | 6.57 | Drop Ship | FBA Price | 14.95
83-XMS1018 | 5538 | Elf Stor | 5.29 |  | 19.98 | 3 | 9.79 | 18.08 | 1.9 | 0.1 | 5.8 | 14.09 |  | 5.89 | 0.29 |  | 19.98 | 3 | 4.79 | 0.22 | 13.29 | 6.69 | 0.33 |  | 19.98 | 3 | 9.79 | 18.08 | 1.9 | 0.1 |  | 13.28 | 11.69 | 0 | 6.4 | 0.55 |  | 13.28 | 11.69 | 6.4 | 0.55 |  | 9.79 | 5.8 |  | 6.69 | FBA | FBA Price | 18.95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | So if AW2 shows FBA Price I want it to show the total cost associated with FBA Price which is in cell V2---and if it shows SFP Price I want it to show the cost associated which is in AC2  and so on for the rest of the 4 values in the drop down list in AW Cells
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FBA Price
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ASC Price
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SFP Price
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]