Good morning all
As you can see form the attached, I am trying to set up a pricing calculator for a client, and I thought Vlook up would be the best way to do this.
However, I am having 2 issues.
1) The calculator works for 4pp and 6pp, but does not work for 8pp, 12pp and 16pp?
2) It also only works if I put in the exact amount that appears in the table, but what I need is if I type 800 for example in D8, then I need it to still use the price in column D?
Any help or guidance would be very much appreciated.
Kind regards,
Craig Kinsey
Bookmarks