Excel Formula / Code

[Vishaal]

We have the following sheet

Excel 2010 32 bit

	A​	B​	C​	D​	E​
1​
2​
3​
4​
5​	​	S.No.​	Year​	​	Batch (Number of Students)​
6​	Entry​	1​	1993​	​	300​
7​	​	2​	1932​	​	320​
8​	​	3​	1978​		800​
9​	​	4​	1924​		400​
10​	​	5​	1912​	​	200​
11​	​	6​	1993​		300​
12​	​	7​	1968​	​	800​
13​		8​	1994​		400​
14​		9​	1924​		400​
15​		10​	1983​		300​
16​		11​	1935​	​	500​
17​		12​	1956​		600​

Sheet: Sheet1

We want a code/formula, who can search the numerical value in cell "E" which we put on cell "D", i mean we will put the code/formula and after that when we put numerical value it will search the value from next cell and when it will find any one value its stop searching.

result sheet
Excel 2010 32 bit

	A​	B​	C​	D​	E​	F​	G​
1​						​
2​						​
3​						​
4​						​
5​	​	S.No.​	Year​	​	Batch (Number of Students)​	​	only for your clarity​
6​	Entry​	1​	1993​	​	300​	​
7​	​	2​	1932​	​	320​	​
8​	​	3​	1978​	300,320,800	800​	​
9​	​	4​	1924​		400​	​
10​	​	5​	1912​	​	200​	​
11​	​	6​	1993​	300,200,400	300​	Find​	S.no. 3 value find here 300
12​	​	7​	1968​	​	800​	​
13​		8​	1994​	400	400​	Find​	S.no. 6 value find here 400
14​		9​	1924​	400,800,300	400​	Find​	S.no. 8 value find here 400
15​		10​	1983​	400,800,300	300​	Find​	S.no. 9 value find here 300
16​		11​	1935​	​	500​	​
17​		12​	1956​		600​	​

Sheet: Sheet1

Help pls

 

[Vishaal]

any formula pls

 

[Vishaal]

any code or formula

 

[Vishaal]

problem solved