Need formula to return a specific label if criteria is met

[Woolley]

Hi,

I need a formula that will show me which range a value falls within.

E.G. The cost is £103.60
Range is
£0 - £100.00
£100.01 - £250.00
£250.01 - £500.00
£500.01 - £1000.00
£1000.01 - £2500.00
£2500.01 - £5000.00
£5000.01 - £10000.00
£10000.01 - £15000.00

so this should return £100.01 - £250.00

Any idea what may work?

[Glenn Kennedy]

It's easy if you set up your price range in two columns:

="£"&VLOOKUP(D3,A:A,1,TRUE)&" - £"&VLOOKUP(D3,A:B,2,TRUE)

[FlameRetired]

Hi Woolley. Welcome to the forum.

A hybrid of Glenn's approach.

Retain the labels in column A.
Copy/paste that to column B.
Do Text to columns.

Then

Please Login or Register  to view this content.

[Woolley]

Worked a treat. Thank you

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.