VLOOKUP

[Aristo]

Hello everybody !
Posted a question two days back, I was 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 got some help, but it is not working...it keeps on telling me that there is too much arguement......
ALL I WANT IS TO CALCULATE HOW MUCH DISCOUNT THE BUSINESS GETS FOR A 12 MONTH PERIOD ON THE SAME ROW LOOKING AT THE COST OF MATERIALS...
Please help,

 

[al_b_cnu]

Hi Aristo,

I think Oaktree answered your post: http://www.mrexcel.com/board2/viewtopic.php?t=179506&highlight=

If that's not what you wanted, could you post further details, e.g. s/sheet format, expected results, preferably via HTMLMaker.