Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
We have the following sheet
Excel 2010 32 bit
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
Help pls
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