# VLOOKUP / HLOOKUP

#### Aristo

##### New Member
Hello everybody ?
I am a bit new to excel, I am trying to calculate a financial spreadsheet for a business, I am having trouble using VLOOKUP to calculate a scenario were the owner gets a 2.5% discount if cost of materials is between £300 and £350, and gets 5% discount if cost of materials is greater than £350.
I would really appreciate it if anyone could help me.....

### Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

#### Oaktree

##### MrExcel MVP
Welcome to the board.

If A1 has the original price,

=A1*LOOKUP(A1,{0,1;300,0.975;350,0.95})

will return the after-discount price.

Replies
1
Views
294
Replies
3
Views
133
Replies
4
Views
239
Replies
3
Views
400
Replies
0
Views
303

1,196,017
Messages
6,012,875
Members
441,737
Latest member
bijayche

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back