EVELYN QUIROZ
New Member
- Joined
- Nov 1, 2022
- Messages
- 6
- Office Version
- 365
- Platform
- Web
Hi, I'd love to receive some feedback about have the right formula for this problem, I'm getting crazy so bad because I understand what I need but regardless I can't find the right formula.
I explain what I am looking for:
I have this first table, Column where the RATE is have to show the price depending the pieces in the column QTY, if they are in the average depending on the table 2.
I undesrtand that I could mix INDEX with MATCH, or even VLOOKUP iwth INDEX and MATCH, but is not working on my side at all, please help me
I explain what I am looking for:
I have this first table, Column where the RATE is have to show the price depending the pieces in the column QTY, if they are in the average depending on the table 2.
| # | DESCRIPTION OF THE PRODUCT (Table 1) | SKU | QTY | RATE | AMOUNT (USD) | |
| 1 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 11 | $ - | |
| 2 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 9 | $ - | |
| 3 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 10 | $ - | |
| 4 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 49 | $ - | |
| 5 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 50 | $ - | |
| 6 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 99 | $ - | |
| 7 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 100 | $ - | |
| 8 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 149 | $ - | |
| 9 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 150 | $ - | |
| 10 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 249 | $ - | |
| 11 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 250 | $ - | |
| 12 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 251 | $ - | |
| 13 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | $ - | ||
| 14 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 3 | $ - | |
| 15 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 15 | $ - | |
| 16 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 55 | $ - | |
| 17 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 110 | $ - | |
| 18 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 170 | $ - | |
| 19 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 280 | $ - | |
| 20 | Amador Training Size 3, Orange/Black/Yellow/Grey | - | SFT1006-3OR | 300 | $ - |
| SKU (table 2) | 1-9 PIECES | 10-49 | 50-99 | 100-149 | 150-199 | 200-249 | 250+ |
| SKU | Retail | 20% | 25% | 30% | 35% | 40% | 50% |
| SFT1006-3OR | $24.99 | $19.99 | $18.74 | $17.49 | $16.24 | $14.99 | $12.50 |
| SFT1006-4OR | $24.99 | $19.99 | $18.74 | $17.49 | $16.24 | $14.99 | $12.50 |
| SFT1006-5OR | $24.99 | $19.99 | $18.74 | $17.49 | $16.24 | $14.99 | $12.50 |
| SFT1006-3YL | $24.99 | $19.99 | $18.74 | $17.49 | $16.24 | $14.99 | $12.50 |
| SFT1006-4YL | $24.99 | $19.99 | $18.74 | $17.49 | $16.24 | $14.99 | $12.50 |
| SFT1006-5YL | $24.99 | $19.99 | $18.74 | $17.49 | $16.24 | $14.99 | $12.50 |
| SFT1006-3WT | $24.99 | $19.99 | $18.74 | $17.49 | $16.24 | $14.99 | $12.50 |
| SFT1006-4WT | $24.99 | $19.99 | $18.74 | $17.49 | $16.24 | $14.99 | $12.50 |
| SFT1006-5WT | $24.99 | $19.99 | $18.74 | $17.49 | $16.24 | $14.99 | $12.50 |
| SFT1002-5OR | $39.99 | $31.99 | $29.99 | $27.99 | $25.99 | $23.99 | $20.00 |
| SFT1005-5GD | $99.99 | $79.99 | $74.99 | $69.99 | $64.99 | $59.99 | $50.00 |
| SFT1009-2OR | $24.99 | $19.99 | $18.74 | $17.49 | $16.24 | $14.99 | $12.50 |
| SFT1009-3OR | $24.99 | $19.99 | $18.74 | $17.49 | $16.24 | $14.99 | $12.50 |
| SFT1009-4OR | $24.99 | $19.99 | $18.74 | $17.49 | $16.24 | $14.99 | $12.50 |
| SFT1009-2YL | $24.99 | $19.99 | $18.74 | $17.49 | $16.24 | $14.99 | $12.50 |
| SFT1009-3YL | $24.99 | $19.99 | $18.74 | $17.49 | $16.24 | $14.99 | $12.50 |
| SFT1009-4YL | $24.99 | $19.99 | $18.74 | $17.49 | $16.24 | $14.99 | $12.50 |
| SFT1010-2GN | $29.99 | $23.99 | $22.49 | $20.99 | $19.49 | $17.99 | $15.00 |
| SFT1010-3GN | $29.99 | $23.99 | $22.49 | $20.99 | $19.49 | $17.99 | $15.00 |
| SFT1010-4GN | $29.99 | $23.99 | $22.49 | $20.99 | $19.49 | $17.99 | $15.00 |
| SFT1010-3LB | $29.99 | $23.99 | $22.49 | $20.99 | $19.49 | $17.99 | $15.00 |
| SFT1010-4LB | $29.99 | $23.99 | $22.49 | $20.99 | $19.49 | $17.99 | $15.00 |
| SFT1011-4RD | $39.99 | $31.99 | $29.99 | $27.99 | $25.99 | $23.99 | $20.00 |
| SFT1012-4EM | $59.99 | $47.99 | $44.99 | $41.99 | $38.99 | $35.99 | $30.00 |
| SFT1050-3 | $32.00 | $25.60 | $24.00 | $22.40 | $20.80 | $19.20 | $16.00 |
| SFT1050-4 | $32.00 | $25.60 | $24.00 | $22.40 | $20.80 | $19.20 | $16.00 |
| SFT1051-3 | $42.00 | $33.60 | $31.50 | $29.40 | $27.30 | $25.20 | $21.00 |
| SFT1051-4 | $42.00 | $33.60 | $31.50 | $29.40 | $27.30 | $25.20 | $21.00 |
| SFT1015-4BK | $39.99 | $31.99 | $29.99 | $27.99 | $25.99 | $23.99 | $20.00 |
| SFT1016-4OR | $29.99 | $23.99 | $22.49 | $20.99 | $19.49 | $17.99 | $15.00 |
| SFT1016-5OR | $29.99 | $23.99 | $22.49 | $20.99 | $19.49 | $17.99 | $15.00 |
| SFT1020-4BL | $29.99 | $23.99 | $22.49 | $20.99 | $19.49 | $17.99 | $15.00 |
| SFT1020-5BL | $29.99 | $23.99 | $22.49 | $20.99 | $19.49 | $17.99 | $15.00 |
| SFT1021-5OR | $39.99 | $31.99 | $29.99 | $27.99 | $25.99 | $23.99 | $20.00 |
| SFT1030-1OR | $14.99 | $11.99 | $11.24 | $10.49 | $9.74 | $8.99 | $7.50 |
| SFT1030-1YL | $14.99 | $11.99 | $11.24 | $10.49 | $9.74 | $8.99 | $7.50 |
| SFT1031-RD | $84.99 | $67.99 | $63.74 | $59.49 | $55.24 | $50.99 | $42.50 |
| SFT2030-Y-GN | $6.49 | $5.19 | $4.87 | $4.54 | $4.22 | $3.89 | $3.25 |
| SFT2030-Y-YL | $6.49 | $5.19 | $4.87 | $4.54 | $4.22 | $3.89 | $3.25 |
| SFT2030-Y-OR | $6.49 | $5.19 | $4.87 | $4.54 | $4.22 | $3.89 | $3.25 |
| SFT2030-Y-BL | $6.49 | $5.19 | $4.87 | $4.54 | $4.22 | $3.89 | $3.25 |
| SFT2030-A-GN | $6.49 | $5.19 | $4.87 | $4.54 | $4.22 | $3.89 | $3.25 |
| SFT2030-A-YL | $6.49 | $5.19 | $4.87 | $4.54 | $4.22 | $3.89 | $3.25 |
| SFT2030-A-OR | $6.49 | $5.19 | $4.87 | $4.54 | $4.22 | $3.89 | $3.25 |
| SFT2030-A-BL | $6.49 | $5.19 | $4.87 | $4.54 | $4.22 | $3.89 | $3.25 |
| SFT3000 | $39.99 | $31.99 | $29.99 | $27.99 | $25.99 | $23.99 | $20.00 |
| SFT3001 | $19.99 | $15.99 | $14.99 | $13.99 | $12.99 | $11.99 | $10.00 |
| SFT1002-5OR | $39.99 | $31.99 | $29.99 | $27.99 | $25.99 | $23.99 | $20.00 |
I undesrtand that I could mix INDEX with MATCH, or even VLOOKUP iwth INDEX and MATCH, but is not working on my side at all, please help me
