Formula to get the data compared to table

[Sathisc]

Hi,

I have the below table with "From (column A), To(Column B) & Unit(Column C)". In E1 when the data is entered, the formula should check if the numbers is between or equal to the number and give the updated units. In the below table if E1 = 200 then E2 should get 3.5(formula) comparing the table.

From	To	Units
0	45	0
46	60	1
61	75	1.25
76	90	1.5
91	105	1.75
106	120	2
121	135	2.25
136	150	2.5
151	165	2.75
166	180	3
181	195	3.25
196	210	3.5
211	225	3.75
226	240	4
241	255	4.25
256	270	4.5
271	285	4.75
286	300	5
301	315	5.25
316	330	5.5
331	345	5.75
346	360	6
361	375	6.25
376	390	6.5
391	405	6.75
406	420	7
421	435	7.25
436	450	7.5
451	465	7.75
466	480	8

<tbody>
</tbody>

thanks in advance

 

[Joe4]

Simply use VLOOKUP with the approximate match argument.
Set you lookup tables exactly as you have shown here.

Let's say that the data is in cells A2:C31, and the value you are looking up is in cell E1.
Then use this formula:

=VLOOKUP(E1,A2:C31,3,TRUE)

You can Google "Excel VLOOKUP" if you want to learn more about VLOOKUP, and see other examples.

 

[Sathisc]

it works. Thank you so much Joe

 

[Joe4]

You are welcome.