I have a sort of price list in Excel which has bands eg
30,000 £1000
50,000 £2000
75,000 £3000
100,000 £4000
150,000 £5000
250,000 £6000
350,000 £7000
550,000 £8000
Each band has a different price associated with it and I want to lookup the price depending on where a value falls within the bands. For example if I entered 120,000 into a cell I want the formula to return £5,000 or 275,000 would give you £7,000
Is there a formula that can do this or do i need to set out my data in a different way?
Thanks
30,000 £1000
50,000 £2000
75,000 £3000
100,000 £4000
150,000 £5000
250,000 £6000
350,000 £7000
550,000 £8000
Each band has a different price associated with it and I want to lookup the price depending on where a value falls within the bands. For example if I entered 120,000 into a cell I want the formula to return £5,000 or 275,000 would give you £7,000
Is there a formula that can do this or do i need to set out my data in a different way?
Thanks