Dropdown list box recognizes multiple lines in cell

[vishu]

Hello friends,
Please need help, I have a dropdown or list box with a formula. Select any list to jump to that particular cell and highlight.
Previously this was done for a single line or word in a cell but now each cell has multiple lines so the dropdown cannot identify which cell it is referring to.

The same question was posted in the mentioned forum a few days back but still not resolved. Please help me.
Dropdown list box recognise mutiple lines in cell

DropDown.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1			#$E$1	1 17016 ^NSEI 17618.75
2
3	1 17016 ^NSEI 17618.75	2 39366.3 ^NSEBANK 42154	1 280.1 VEDL.NS 281.35	1 87.55 SAIL.NS 82.7	1 24878.05 SHREECEM.NS 24720	1 712.1 SBICARD.NS 758.8	1 136.7 RBLBANK.NS 148.6	1 177.8 NTPC.NS 166.95	1 1481.45 MCX.NS 1443	1 113.2 MANAPPURAM.NS 129.65	1 646.1 LUPIN.NS 686.35	1 6.3 IDEA.NS 6.1						1 17016 ^NSEI 17618.75
4	1 996 INDUSINDBK.NS 1118.8	1 76.7 IDFC.NS 80.7	1 54.55 IDFCFIRSTB.NS 56.3	1 34800 HONAUT.NS 35502.15	1 1662.15 CUMMINSIND.NS 1504	1 524.3 CANFINHOME.NS 565	1 4386 BRITANNIA.NS 4306	1 198.25 BANDHANBNK.NS 214	1 5586.15 BAJFINANCE.NS 5940	1 572.55 AMARAJABAT.NS 608.85	2 1109.85 TECHM.NS 1012.05	2 1180.95 TATACOMM.NS 1188						2 39366.3 ^NSEBANK 42154
5	2 1075.05 SBILIFE.NS 1123	2 717.05 RAMCOCEM.NS 743.75	2 2217 RELIANCE.NS 2348.8	2 4581.75 PERSISTENT.NS 4328.6	2 1277 METROPOLIS.NS 1271.55	2 435.05 JUBLFOOD.NS 437.45	2 839.05 ICICIBANK.NS 892.1	2 2552.15 HDFC.NS 2743	2 466.5 HDFCLIFE.NS 524.95	2 1556.2 HDFCBANK.NS 1668.7	2 1690.15 HDFCAMC.NS 1767.75	2 1105.75 HCLTECH.NS 1037.5						1 280.1 VEDL.NS 281.35
6	2 1176.05 HAVELLS.NS 1214.95	2 522.7 GNFC.NS 533.8	2 41.45 GMRINFRA.NS 44.35	2 281.25 CROMPTON.NS 292.05	2 18122.6 BOSCHLTD.NS 18665	2 159.3 BANKBARODA.NS 177.1	2 838.75 AXISBANK.NS 871.95	2 305.95 APOLLOTYRE.NS 332.45	2 3299 ABB.NS 3199.9	3 534.7 TORNTPOWER.NS 533.2	3 1532 TORNTPHARM.NS 1597.5	3 227.7 POWERGRID.NS 230.9						1 87.55 SAIL.NS 82.7
7	3 79.75 NATIONALUM.NS 83.8	3 939 MUTHOOTFIN.NS 1045	3 83232.2 MRF.NS 85876.5	3 1065.1 ICICIGI.NS 1077	3 2454.4 HINDUNILVR.NS 2523.5	3 127.6 FEDERALBNK.NS 131.4	3 2865.05 DIXON.NS 3005.4	3 370.5 BALRAMCHIN.NS 422	4 1322.75 WHIRLPOOL.NS 1326.9	4 704.65 UPL.NS 736.6	4 7237.1 ULTRACEMCO.NS 7516	4 700 TATACONSUM.NS 701						1 24878.05 SHREECEM.NS 24720
8	4 3401.25 NAUKRI.NS 3615.25	4 1692 KOTAKBANK.NS 1886	4 405.25 INTELLECT.NS 428.2	4 434.25 IGL.NS 487.55	4 602.15 IRCTC.NS 605.85	4 1587.75 GRASIM.NS 1690.95	4 1081.9 GODREJPROP.NS 1291	4 176.75 EXIDEIND.NS 188.1	4 4409.2 DRREDDY.NS 4910.05	4 192.35 DELTACORP.NS 190.5	4 1795.05 DALBHARAT.NS 2055.85	4 742.2 CHOLAFIN.NS 845.6						1 712.1 SBICARD.NS 758.8
9	4 74 BHEL.NS 75.45	4 150 ABCAPITAL.NS 161.2	4 517.5 AARTIIND.NS 544.55	5 473.35 ZYDUSLIFE.NS 515.45	5 206.5 ZEEL.NS 198.15	5 105.95 TATASTEEL.NS 108.1	5 428.3 SUNTV.NS 420	5 953.25 SUNPHARMA.NS 995	5 2351.1 PIDILITIND.NS 2409	5 113.95 NMDC.NS 113.1	5 18698.7 NESTLEIND.NS 20595.05	5 312.65 INDHOTEL.NS 330.9						1 136.7 RBLBANK.NS 148.6
10	5 4900.5 INDIAMART.NS 5404.05	5 404.75 ICICIPRULI.NS 446	5 941.05 GODREJCP.NS 967.85	5 432.6 GLENMARK.NS 512	5 366.3 DLF.NS 419.85	5 531.15 DABUR.NS 520	5 3796.75 BAJAJ-AUTO.NS 4265	5 466 AUROPHARMA.NS 587.5	5 6985 ATUL.NS 6934.5	5 2814.85 ASIANPAINT.NS 2811	5 366.2 AMBUJACEM.NS 380	5 3099.15 ALKEM.NS 3354						1 177.8 NTPC.NS 166.95
11	5 21120.1 ABBOTINDIA.NS 22730	6 2468.05 TITAN.NS 2566.05	6 573.3 SYNGENE.NS 614.55	6 1536 PVR.NS 1502.5	6 230.05 PETRONET.NS 233.75	6 37744.75 PAGEIND.NS 38000	6 999.45 MGL.NS 1010.3	6 149.1 IEX.NS 152.7	6 107.85 GAIL.NS 108.25	6 588.75 CONCOR.NS 599.1	6 591 BERGEPAINT.NS 574.8	7 3228.5 OFSS.NS 3289.95						1 1481.45 MCX.NS 1443
12	7 378.85 ITC.NS 398.2	7 510 GUJGASLTD.NS 464.2	7 674.4 ADANIPORTS.NS 656.65	8 370.25 WIPRO.NS 361.25	8 203.8 TATAPOWER.NS 193.55	8 418.4 TATAMOTORS.NS 469.3	8 3156.75 TCS.NS 3089	8 1288.65 SHRIRAMFIN.NS 1362	8 120.1 RECLTD.NS 122.95	8 157 RAIN.NS 158.2	8 156.35 PFC.NS 161.6	8 3029 PIIND.NS 3148						1 113.2 MANAPPURAM.NS 129.65
13	8 872.4 OBEROIRLTY.NS 916.7	8 66.4 MOTHERSON.NS 68.95	8 102 IBULHSGFIN.NS 101.85	8 99.9 HINDCOPPER.NS 101.2	8 2675.95 HAL.NS 2816.8	8 218.95 COALINDIA.NS 230.15	8 204.2 BIOCON.NS 228.35	8 766 BHARTIARTL.NS 766	8 793.2 BHARATFORG.NS 779	8 93.95 BEL.NS 101.35	8 586.95 AUBANK.NS 678.75	8 139.25 ASHOKLEY.NS 137.8						1 646.1 LUPIN.NS 686.35
14	8 221 ABFRL.NS 220.9	8 1746 ACC.NS 1744	9 1076.2 TVSMOTOR.NS 1168.9	9 965.8 TATACHEM.NS 933	9 527 SBIN.NS 539.4	9 48.35 PNB.NS 48.4	9 2906.1 POLYCAB.NS 3137.95	9 153.75 ONGC.NS 159.65	9 1836.85 MPHASIS.NS 1781.05	9 4795 LTIM.NS 4189	9 347.8 LICHSGFIN.NS 331	9 307.3 LAURUSLABS.NS 311.5						1 6.3 IDEA.NS 6.1
15	9 86.85 L&TFH.NS 87.85	9 182.9 INDIACEM.NS 187.35	9 274.75 GSPL.NS 265.3	9 290.8 GRANULES.NS 303.7	9 2975 EICHERMOT.NS 3288.5	9 872 COROMANDEL.NS 946.95	9 3799.8 COFORGE.NS 3894	9 130.45 CUB.NS 128.7	9 273.6 CHAMBLFERT.NS 282.5	9 288.45 CANBK.NS 295	9 1354.95 ASTRAL.NS 1431.5	9 1861 ADANIENT.NS 1851						1 996 INDUSINDBK.NS 1118.8
16	10 1451 UBL.NS 1409	10 8289.6 MARUTI.NS 8674.3	10 1180.5 M&M.NS 1215.45	10 2873 JKCEMENT.NS 3024	10 1407.25 INFY.NS 1230.95	10 1925 ESCORTS.NS 1987	10 274.7 BSOFT.NS 257.75	10 2014.7 BALKRISIND.NS 2021.95	11 859.3 VOLTAS.NS 851.25	11 3275.7 SIEMENS.NS 3260.85	11 3528.15 LTTS.NS 3428.55	11 1848.95 LALPATHLAB.NS 1904.95						1 76.7 IDFC.NS 80.7
17	11 565.3 JINDALSTEL.NS 580.45	11 1865.65 INDIGO.NS 1963.25	11 154.2 INDUSTOWER.NS 136.6	11 396.75 HINDALCO.NS 432.7	12 1318.05 TRENT.NS 1357.65	12 109.3 FSL.NS 113.95	12 350.75 BPCL.NS 342.8	12 1397.95 BATAINDIA.NS 1432.8	13 761.2 MCDOWELL-N.NS 758	13 2182 LT.NS 2218	14 79.1 IOC.NS 78.7	14 242.1 HINDPETRO.NS 238.7						1 54.55 IDFCFIRSTB.NS 56.3
18	15 2298.55 SRF.NS 2471.9	17 484.9 MARICO.NS 467.9	18 1489.4 COLPAL.NS 1526.5	19 4374.95 NAVINFLUOR.NS 4625	19 2823 DIVISLAB.NS 3334.7	21 236.8 M&MFIN.NS 260.4	21 4353.9 APOLLOHOSP.NS 4309.75	22 687.5 PEL.NS 715.65	22 671.5 JSWSTEEL.NS 723.6	22 872.4 CIPLA.NS 912.8	22 1314.95 BAJAJFINSV.NS 1332.4	23 787.45 IPCALAB.NS 830						1 34800 HONAUT.NS 35502.15
19	24 1790 DEEPAKNTR.NS 1842.9	26 672 MFSL.NS 635.45	42 2369.25 HEROMOTOCO.NS 2446.5															1 1662.15 CUMMINSIND.NS 1504
20																		1 524.3 CANFINHOME.NS 565
21																		1 4386 BRITANNIA.NS 4306
22																		1 198.25 BANDHANBNK.NS 214
23																		1 5586.15 BAJFINANCE.NS 5940
24																		1 572.55 AMARAJABAT.NS 608.85
25																		2 1109.85 TECHM.NS 1012.05
26																		2 1180.95 TATACOMM.NS 1188
27																		2 1075.05 SBILIFE.NS 1123
28																		2 717.05 RAMCOCEM.NS 743.75
29																		2 2217 RELIANCE.NS 2348.8
30																		2 4581.75 PERSISTENT.NS 4328.6
31																		2 1277 METROPOLIS.NS 1271.55
32																		2 435.05 JUBLFOOD.NS 437.45
33																		2 839.05 ICICIBANK.NS 892.1
34																		2 2552.15 HDFC.NS 2743
35																		2 466.5 HDFCLIFE.NS 524.95
36																		2 1556.2 HDFCBANK.NS 1668.7
All_Screener

Cell Formulas
Range	Formula
D1	D1	=HYPERLINK("#"&CELL("address",E1))
B19:D19,B3:M18	B3	=OFFSET($S$3,COLUMNS($S:S)-1+(ROWS($1:1)-1)*12,0)

 

[Fluff]

Glad to help & thanks for the feedback.