Number Range LookUp

[108monkeys]

How can I find the Input Value from the Return Value using the following Range Table?

Value​	Input​		Min​	Max​	Return​
55​	=		0​	49​	0​
			50​	99​	50​
			100​	149​	100​
			150​	199​	150​
			200​	249​	200​
			250​	299​	250​
			300​	349​	300​
			350​	399​	350​
			400​	449​	400​
			450​	499​	450​
			500​	549​	500​
			550​	599​	550​
			600​	649​	600​
			650​	699​	650​
			700​	749​	700​
			750​	799​	750​
			800​	849​	800​
			850​	899​	850​
			900​	949​	900​
			950​	999​	950​
			1000​	1049​	1000​

Much appreciated,
Hanuman

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

What is your expected result for that sample and how to you get that result manually?

 

[Peter_SSs]

Is this what you are after?

21 10 07.xlsm
	A	B	C	D	E	F
1	Value	Input		Min	Max	Return
2	55	50		0	49	0
3				50	99	50
4				100	149	100
5				150	199	150
6				200	249	200
7				250	299	250
8				300	349	300
9				350	399	350
10				400	449	400
11				450	499	450
12				500	549	500
13				550	599	550
14				600	649	600
15				650	699	650
16				700	749	700
17				750	799	750
18				800	849	800
19				850	899	850
20				900	949	900
21				950	999	950
22				1000	1049	1000
Lookup

Cell Formulas
Range	Formula
B2	B2	=LOOKUP(A2,D$2:D$22)

 

[108monkeys]

Thank you sir

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.