VLOOKUP for a range of data rather than specific values?

  • Thread starter Thread starter tHatDudeUK
  • Start date Start date
T

tHatDudeUK

I'm hoping this is an easy one.

I have a table with a list to lookup from which is like as follows.

<£137.00 £2.30
£137.00-£234.99 £4.60
£235.00 - £292.99 £5.80
£293.00 £6.95
Click to expand...

I want to lookup a value from the right hand side based on where my value
lies in the left hand side.

Hope you can help me

Thanks in advance

Kind regards

tHatDudeUK
 
Create a table

0 2.3
137 4.6
235 5.8
293 6.95


assume that the table dimensions are A1:B4

then use a formula

=VLOOKUP(Lookup_Value,A1:B4,2)
 
Back
Top