Search in Excel

[Vishaal]

Hi,

Thanks in advance.

May i search the following value/text

13452
3009
12744

in given sheet

Excel 2010 32 bit

	A​	B​
1​
2​	10089​
3​	3363​
4​	13452​
5​	3009​
6​	12744​
7​	12744​
8​	56000​
9​	56000​
10​	66080​
11​	56000​
12​	10620​
13​	17700​
14​	10620​
15​	17700​
16​	10620​
17​	5310​
18​	7080​
19​	7080​
20​	5310​
21​	10620​
22​	3363​
23​	13452​
24​	13452​
25​	3009​
26​	12744​
27​	56000​
28​	56000​
29​	66080​
30​	56000​
31​	10620​
32​	17700​
33​	10620​
34​	17700​
35​	10620​
36​	5310​
37​	7080​
38​	7080​
39​	5310​
40​	10620​

Sheet: Sheet1

pls help

 

[Vishaal]

Thanks for the help Salim Hasan Ji
I am trying to paste in E2 with the following procedure but its not working

Copy the formula
Press F2
Paste the formula
Ctrl+Shift+Enter

Also tried
Copy the formula
Paste the formula
Ctrl+Shift+Enter

Pls advice

 

[Vishaal]

Thanks tyija1995 Ji,

But i dont know why your formula is not working now for me

Pls advice