Hi all, I have a Price list on a data sheet where if the quantity to order is between 1-5 then theirs is a fixed price. Is there a macro where once for example 2 qty is selected the price for 1-5 is pulled into the quote sheet?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,140
- Office Version
- 365
- Platform
- Windows
You really haven't given us enough details, but if you have a price listing somewhere, you perhaps you can use the VLOOKUP formula, making use of the 4th argument (for approximate matches).
Have a look here for details and examples: How to use vlookup exact and approximate match in Excel?
If you need more help, please provide more details, like where these prices are coming from.
It may be helpful to post some images of your data, which you can do using the tool mentioned here: XL2BB - Excel Range to BBCode
Have a look here for details and examples: How to use vlookup exact and approximate match in Excel?
If you need more help, please provide more details, like where these prices are coming from.
It may be helpful to post some images of your data, which you can do using the tool mentioned here: XL2BB - Excel Range to BBCode
Upvote
0
