Returning unit price based on Qty from a customer price book with price qty breaks

Originally Posted by jpr73

Hi,
A solution using Vlookup and if condition
I'm not satisfied with this solution and I'm sure a guru will find a better solution
Hope this help
Best regards

Thanks, if only there was no manually typed criterias in the lookups then that would work.

This is going to be applied to a 50,000 row pricebook so typing manual lookups wouldn't work unfortunately