samilynn
Board Regular
- Joined
- Jun 24, 2003
- Messages
- 166
- Office Version
- 2016
- Platform
- Windows
Hi guys, I have this table on one spreadsheet. On a different spreadsheet, I want to enter just the Item Number and a Qty, and then a vlookup (I think?) that would give me the proper bonus, based on the item and what qty I am selling.
Can you guide me in the right direction with which formula(s) to use?
Thanks,
Samantha
Can you guide me in the right direction with which formula(s) to use?
Thanks,
Samantha
ITEM | QTY | BONUS | QTY | BONUS | QTY | BONUS |
Q7588 | 1 | $2.00 | 10 | $25.00 | 50 | $200.00 |
R4261 | 2 | $10.00 | 25 | $225.00 | 75 | $900.00 |
B4490 | 1 | $20.00 |