Spreadsheet: 222752d1363926712-data-auto-fill-auto-fill
Sheet: Sheet1

INDEX_FLG | SYMBOL | SERIES | SECURITY | ISSUE_CAP | INVESTIBLE_FACTOR | CLOSE_PRIC | FF_MKT_CAP | WEIGHTAGE
BANK Nifty | AXISBANK | EQ | AXIS BANK LIMITED | 467381027 | 0.6739 | 1352.8 |  |  |  | BANK Nifty |  |  |  | BANK Nifty
BANK Nifty | BANKBARODA | EQ | BANK OF BARODA | 411123383 | 0.409285 | 725 |  |  |  | CNX IT |  |  |  | Starting here, I should be able to get the symbols from column B (one below the other), based on the Index Name in the above cell.
BANK Nifty | BANKINDIA | EQ | BANK OF INDIA | 573780370 | 0.325204 | 321.05 |  |  |  | [NAME]
BANK Nifty | CANBK | EQ | CANARA BANK | 443000000 | 0.322799 | 434.8 |  |  |  | CNX Infrastructure
BANK Nifty | HDFCBANK | EQ | HDFC BANK LTD | 2375100145 | 0.770608 | 649.25 |  |  |  | CNX ENERGY
BANK Nifty | ICICIBANK | EQ | ICICI BANK LTD. | 1153234650 | 1 | 1110.65 |  |  |  | CNX FMCG
BANK Nifty | INDUSINDBK | EQ | INDUSIND BANK LIMITED | 522370940 | 0.79888 | 431.15 |  |  |  | [NAME]
BANK Nifty | KOTAKBANK | EQ | KOTAK MAHINDRA BANK LTD | 745407328 | 0.504857 | 658.25 |  |  |  | [NAME]
BANK Nifty | PNB | EQ | PUNJAB NATIONAL BANK | 339178683 | 0.392304 | 796.7 |  |  |  | CNX PSE
BANK Nifty | SBIN | EQ | STATE BANK OF INDIA | 671045274 | 0.384166 | 2255.05 |  |  |  | CNX PSU BANK
BANK Nifty | UNIONBANK | EQ | UNION BANK OF INDIA | 550549035 | 0.408897 | 232 |  |  |  | CNX SERVICE
BANK Nifty | YESBANK | EQ | YES BANK LIMITED | 358072739 | 0.742022 | 484.75
CNX IT | CMC | EQ | CMC LTD | 30300000 | 0.488781 | 1317.2
CNX IT | COREEDUTEC | EQ | CORE EDUCATION & TECH LTD | 114483826 | 0.535488 | 61.7
CNX IT | ECLERX | EQ | ECLERX SERVICES LTD | 29702384 | 0.462157 | 646.15
CNX IT | EDUCOMP | EQ | EDUCOMP SOLUTIONS LTD | 122407493 | 0.374798 | 78.4
CNX IT | FINANTECH | EQ | FINANCIAL TECHNO (I) LTD | 46078537 | 0.460897 | 796.4
CNX IT | HCLTECH | EQ | HCL TECHNOLOGIES LTD | 694931380 | 0.378712 | 791.55
CNX IT | HEXAWARE | EQ | HEXAWARE TECHNOLOGIES LTD | 296742541 | 0.718835 | 89
CNX IT | INFY | EQ | INFOSYS LIMITED | 574236166 | 0.839639 | 2874.1
CNX IT | KPIT | EQ | KPIT CUMMINS INFOSYSTEMS | 192642977 | 0.63528 | 105.1
CNX IT | MINDTREE | EQ | MINDTREE LIMITED | 41525663 | 0.709893 | 858.55
CNX IT | MPHASIS | EQ | MPHASIS LIMITED | 210124709 | 0.349359 | 381.1
CNX IT | NAUKRI | EQ | INFO EDGE (I) LTD | 109181024 | 0.441229 | 355
CNX IT | NIITTECH | EQ | NIIT TECHNOLOGIES LTD | 60181909 | 0.686705 | 280.7
CNX IT | OFSS | EQ | ORACLE FIN SERV SOFT LTD. | 84055328 | 0.196897 | 2743.45
CNX IT | POLARIS | EQ | POLARIS FIN TECH LTD | 99506074 | 0.484411 | 119.1
CNX IT | ROLTA | EQ | ROLTA INDIA LTD | 161329096 | 0.557786 | 65.7
CNX IT | TCS | EQ | TATA CONSULTANCY SERV LT | 1957220996 | 0.260397 | 1567.7
CNX IT | TECHM | EQ | TECH MAHINDRA LIMITED | 127964338 | 0.524854 | 1104.3
CNX IT | VAKRANSOFT | EQ | VAKRANGEE SOFT LIMITED | 502195960 | 0.657115 | 67.2
CNX IT | WIPRO | EQ | WIPRO LTD | 2462818555 | 0.211751 | 438.5
[NAME] | ANANTRAJ | EQ | ANANT RAJ LIMITED | 295096335 | 0.378397 | 68.95
[NAME] | DBREALTY | EQ | D B REALTY LIMITED | 243258782 | 0.388158 | 74.15
[NAME] | DLF | EQ | DLF LIMITED | 1698670836 | 0.214206 | 284.7
[NAME] | GODREJPROP | EQ | GODREJ PROPERTIES LTD | 78046103 | 0.232236 | 537.35
[NAME] | HDIL | EQ | HOUSING DEV & INFRA LTD | 419003986 | 0.626407 | 67.8
[NAME] | IBREALEST | EQ | INDIABULLS REAL EST. LTD | 424010739 | 0.556235 | 64.3
[NAME] | OBEROIRLTY | EQ | OBEROI REALTY LIMITED | 328233262 | 0.215143 | 287.2
[NAME] | PARSVNATH | EQ | PARSVNATH DEVELOPER LTD | 435181170 | 0.284236 | 41.65
[NAME] | [NAME] | EQ | [NAME] DEVELOPERS LTD | 98063868 | 0.394177 | 409.55
[NAME] | UNITECH | EQ | UNITECH LTD | 2616301047 | 0.516509 | 29.65
CNX Infrastructure | ADANIPORTS | EQ | ADANI PORT & SEZ LTD | 2003394100 | 0.225046 | 139.95
CNX Infrastructure | ADANIPOWER | EQ | ADANI POWER LTD | 2393272110 | 0.160621 | 49.75
CNX Infrastructure | BHARTIARTL | EQ | BHARTI AIRTEL LIMITED | 3797530096 | 0.315048 | 314.6
CNX Infrastructure | BHEL | EQ | BHEL | 2447600000 | 0.322785 | 198.85
CNX Infrastructure | CESC | EQ | CESC LTD | 124935925 | 0.475152 | 303.85
CNX Infrastructure | CROMPGREAV | EQ | CROMPTON GREAVES LTD | 641491536 | 0.583079 | 98.8
CNX Infrastructure | GMRINFRA | EQ | GMR INFRASTRUCTURE LTD. | 3892434782 | 0.283613 | 20.35
CNX Infrastructure | IDEA | EQ | IDEA CELLULAR LIMITED | 3313505065 | 0.241875 | 114.1
CNX Infrastructure | IRB | EQ | IRB INFRA DEV LTD. | 332364110 | 0.373376 | 124.1
CNX Infrastructure | IVRCLINFRA | EQ | IVRCL LIMITED | 306886648 | 0.863037 | 25.5
CNX Infrastructure | JPASSOCIAT | EQ | JAIPRAKASH ASSOCIATES LTD | 2219083559 | 0.539217 | 76.45
CNX Infrastructure | JSWENERGY | EQ | JSW ENERGY LIMITED | 1640054795 | 0.232787 | 58.85
CNX Infrastructure | LT | EQ | LARSEN & TOUBRO LTD. | 615385981 | 0.879003 | 1522.05
CNX Infrastructure | NHPC | EQ | NHPC LTD | 12300742773 | 0.136364 | 20.7
CNX Infrastructure | NTPC | EQ | NTPC LTD | 8245464400 | 0.25 | 146.85
CNX Infrastructure | POWERGRID | EQ | POWER GRID CORP. LTD. | 4629725353 | 0.305785 | 109.65
CNX Infrastructure | PTC | EQ | PTC INDIA LIMITED | 296008321 | 0.80406 | 64.35
CNX Infrastructure | PUNJLLOYD | EQ | PUNJ LLOYD LIMITED | 332095745 | 0.62848 | 47.1
CNX Infrastructure | RCOM | EQ | RELIANCE COMMUNICATIONS L | 2064026881 | 0.321371 | 68.15
CNX Infrastructure | [NAME] | EQ | RELIANCE INFRASTRUCTU LTD | 262990000 | 0.514708 | 430.05
CNX Infrastructure | RPOWER | EQ | RELIANCE POWER LTD. | 2805126466 | 0.25 | 75.35
CNX Infrastructure | SIEMENS | EQ | SIEMENS LTD | 355494746 | 0.252902 | 538.85
CNX Infrastructure | TATACOMM | EQ | TATA COMMUNICATIONS LTD | 285000000 | 0.238495 | 233.75
CNX Infrastructure | TATAPOWER | EQ | TATA POWER CO LTD | 2373072360 | 0.682463 | 100.7
CNX Infrastructure | VOLTAS | EQ | VOLTAS LTD | 330884740 | 0.698525 | 84.5
CNX ENERGY | BPCL | EQ | BHARAT PETROLEUM CORP  LT | 723084248 | 0.357395 | 397.25
CNX ENERGY | CAIRN | EQ | CAIRN INDIA LIMITED | 1910177499 | 0.309453 | 295.9
CNX ENERGY | [NAME] | EQ | [NAME] (INDIA) LTD | 1268477400 | 0.354112 | 332.55
CNX ENERGY | IOC | EQ | INDIAN OIL CORP LTD | 2427952482 | 0.0991 | 309.8
CNX ENERGY | NTPC | EQ | NTPC LTD | 8245464400 | 0.25 | 146.85
CNX ENERGY | ONGC | EQ | OIL AND NATURAL GAS CORP. | 8555490120 | 0.206817 | 319.9
CNX ENERGY | POWERGRID | EQ | POWER GRID CORP. LTD. | 4629725353 | 0.305785 | 109.65
CNX ENERGY | RELIANCE | EQ | RELIANCE INDUSTRIES LTD | 3228815229 | 0.508329 | 860.05
CNX ENERGY | RPOWER | EQ | RELIANCE POWER LTD. | 2805126466 | 0.25 | 75.35
CNX ENERGY | TATAPOWER | EQ | TATA POWER CO LTD | 2373072360 | 0.682463 | 100.7
CNX FMCG | BRITANNIA | EQ | BRITANNIA INDUSTRIES LTD | 119525815 | 0.490751 | 537.5
CNX FMCG | COLPAL | EQ | COLGATE PALMOLIVE LTD. | 135992817 | 0.49 | 1317.3
CNX FMCG | DABUR | EQ | DABUR INDIA LTD | 1742935011 | 0.313377 | 133.5
CNX FMCG | EIDPARRY | EQ | EID PARRY INDIA LTD | 173928286 | 0.54291 | 166.05
CNX FMCG | EMAMILTD | EQ | EMAMI LIMITED | 151311746 | 0.272633 | 593.75
CNX FMCG | GODREJCP | EQ | GODREJ CONSUMER PRODUCTS | 340326031 | 0.315825 | 767.15
CNX FMCG | GSKCONS | EQ | [NAME] | 42055538 | 0.568374 | 4196.65
CNX FMCG | HINDUNILVR | EQ | HINDUSTAN UNILEVER LTD. | 2162071008 | 0.474802 | 456.05
CNX FMCG | ITC | EQ | ITC LTD | 7887414150 | 0.693705 | 301.9
CNX FMCG | JUBLFOOD | EQ | JUBILANT FOODWORKS LTD | 65229730 | 0.447878 | 1260.85
CNX FMCG | MARICO | EQ | MARICO LIMITED | 644750599 | 0.357026 | 217.4
CNX FMCG | MCDOWELL-N | EQ | UNITED SPIRITS LIMITED | 130794968 | 0.698473 | 1959.05
CNX FMCG | [NAME] | EQ | MCLEOD RUSSEL INDIA LTD. | 109455735 | 0.542887 | 346.6
CNX FMCG | TATAGLOBAL | EQ | TATA GLOBAL BEVERAGES LTD | 618398570 | 0.647989 | 134.35
CNX FMCG | UBL | EQ | UNITED BREWERIES LTD | 264405149 | 0.251775 | 694.8
[NAME] | ABB | EQ | ABB LTD. | 211908375 | 0.25 | 586.55
[NAME] | AMBUJACEM | EQ | AMBUJA CEMENTS LTD | 1542184436 | 0.494024 | 190.55
[NAME] | BOSCHLTD | EQ | BOSCH LIMITED | 31398900 | 0.28821 | 8705.05
[NAME] | CAIRN | EQ | CAIRN INDIA LIMITED | 1910177499 | 0.309453 | 295.9
[NAME] | CASTROL | EQ | CASTROL INDIA LTD | 494561192 | 0.28969 | 329.6
[NAME] | COLPAL | EQ | COLGATE PALMOLIVE LTD. | 135992817 | 0.49 | 1317.3
[NAME] | CUMMINSIND | EQ | CUMMINS INDIA LTD | 277200000 | 0.489998 | 500.55
[NAME] | GLAXO | EQ | [NAME] LT | 84703017 | 0.493318 | 2117.55
[NAME] | HINDUNILVR | EQ | HINDUSTAN UNILEVER LTD. | 2162071008 | 0.474802 | 456.05
[NAME] | MARUTI | EQ | MARUTI SUZUKI INDIA LTD. | 288910060 | 0.457899 | 1418.8
[NAME] | MPHASIS | EQ | MPHASIS LIMITED | 210124709 | 0.349359 | 381.1
[NAME] | OFSS | EQ | ORACLE FIN SERV SOFT LTD. | 84055328 | 0.196897 | 2743.45
[NAME] | RANBAXY | EQ | RANBAXY LABS LTD | 423006853 | 0.364619 | 432.65
[NAME] | SESAGOA | EQ | SESA GOA LTD | 869101423 | 0.448725 | 165.15
[NAME] | SIEMENS | EQ | SIEMENS LTD | 355494746 | 0.252902 | 538.85
[NAME] | [NAME] | EQ | CADILA HEALTHCARE LIMITED | 204748519 | 0.252068 | 757.9
[NAME] | CIPLA | EQ | CIPLA LTD | 802921357 | 0.631986 | 385.25
[NAME] | DIVISLAB | EQ | DIVI'S LABORATORIES LTD | 132734290 | 0.478491 | 1024.35
[NAME] | DRREDDY | EQ | DR. REDDY'S LABORATORIES | 169836475 | 0.744351 | 1817
[NAME] | GLAXO | EQ | [NAME] LT | 84703017 | 0.493318 | 2117.55
[NAME] | GLENMARK | EQ | GLENMARK PHARMACEUTICALS | 270844153 | 0.516765 | 497.55
[NAME] | [NAME] | EQ | LUPIN LIMITED | 447495890 | 0.531526 | 600.1
[NAME] | PEL | EQ | PIRAMAL ENTERPRISES LTD | 173268629 | 0.4451 | 581.25
[NAME] | RANBAXY | EQ | RANBAXY LABS LTD | 423006853 | 0.364619 | 432.65
[NAME] | SUNPHARMA | EQ | SUN PHARMACEUTICALS IND. | 1035581955 | 0.363181 | 830.15
CNX PSE | BEL | EQ | BHARAT ELECTRONICS LTD | 80000000 | 0.24138 | 1176.7
CNX PSE | BHEL | EQ | BHEL | 2447600000 | 0.322785 | 198.85
CNX PSE | BPCL | EQ | BHARAT PETROLEUM CORP  LT | 723084248 | 0.357395 | 397.25
CNX PSE | COALINDIA | EQ | COAL INDIA LTD | 6316364400 | 0.1 | 319.2
CNX PSE | CONCOR | EQ | CONTAINER CORP OF IND LTD | 129982794 | 0.369149 | 1066.25
CNX PSE | ENGINERSIN | EQ | ENGINEERS INDIA LTD | 336936600 | 0.19599 | 181.75
CNX PSE | [NAME] | EQ | [NAME] (INDIA) LTD | 1268477400 | 0.354112 | 332.55
CNX PSE | HINDPETRO | EQ | HINDUSTAN PETROLEUM CORP | 338627250 | 0.488887 | 305.4
CNX PSE | IOC | EQ | INDIAN OIL CORP LTD | 2427952482 | 0.0991 | 309.8
CNX PSE | NATIONALUM | EQ | NATIONAL ALUMINIUM CO LTD | 2577238512 | 0.117402 | 44.1
CNX PSE | NHPC | EQ | NHPC LTD | 12300742773 | 0.136364 | 20.7
CNX PSE | NMDC | EQ | NMDC LTD. | 3964716000 | 0.199956 | 145.6
CNX PSE | NTPC | EQ | NTPC LTD | 8245464400 | 0.25 | 146.85
CNX PSE | OIL | EQ | OIL INDIA LTD | 601135955 | 0.226653 | 549
CNX PSE | ONGC | EQ | OIL AND NATURAL GAS CORP. | 8555490120 | 0.206817 | 319.9
CNX PSE | PFC | EQ | POWER FIN CORP LTD. | 1320015011 | 0.262839 | 198.45
CNX PSE | POWERGRID | EQ | POWER GRID CORP. LTD. | 4629725353 | 0.305785 | 109.65
CNX PSE | RECLTD | EQ | RURAL ELEC CORP. LTD. | 987459000 | 0.332016 | 223.1
CNX PSE | SAIL | EQ | STEEL AUTHORITY OF INDIA | 4130525289 | 0.141831 | 70.55
CNX PSE | SCI | EQ | SHIPPING CORP OF INDIA LT | 465799010 | 0.362508 | 47
CNX PSU BANK | ALBK | EQ | ALLAHABAD BANK | 500026189 | 0.399979 | 141.75
CNX PSU BANK | ANDHRABANK | EQ | ANDHRA BANK | 559580364 | 0.419958 | 100.4
CNX PSU BANK | BANKBARODA | EQ | BANK OF BARODA | 411123383 | 0.409285 | 725
CNX PSU BANK | BANKINDIA | EQ | BANK OF INDIA | 573780370 | 0.325204 | 321.05
CNX PSU BANK | CANBK | EQ | CANARA BANK | 443000000 | 0.322799 | 434.8
CNX PSU BANK | IDBI | EQ | IDBI BANK LIMITED | 1278377111 | 0.268604 | 90.15
CNX PSU BANK | IOB | EQ | INDIAN OVERSEAS BANK | 796998198 | 0.264994 | 71.4
CNX PSU BANK | ORIENTBANK | EQ | ORIENTAL BANK OF COMMERCE | 291761182 | 0.42 | 278.7
CNX PSU BANK | PNB | EQ | PUNJAB NATIONAL BANK | 339178683 | 0.392304 | 796.7
CNX PSU BANK | SBIN | EQ | STATE BANK OF INDIA | 671045274 | 0.384166 | 2255.05
CNX PSU BANK | SYNDIBANK | EQ | SYNDICATE BANK | 601949955 | 0.290722 | 123.55
CNX PSU BANK | UNIONBANK | EQ | UNION BANK OF INDIA | 550549035 | 0.408897 | 232
CNX SERVICE | AXISBANK | EQ | AXIS BANK LIMITED | 467381027 | 0.6739 | 1352.8
CNX SERVICE | BANKBARODA | EQ | BANK OF BARODA | 411123383 | 0.409285 | 725
CNX SERVICE | BANKINDIA | EQ | BANK OF INDIA | 573780370 | 0.325204 | 321.05
CNX SERVICE | BHARTIARTL | EQ | BHARTI AIRTEL LIMITED | 3797530096 | 0.315048 | 314.6
CNX SERVICE | CANBK | EQ | CANARA BANK | 443000000 | 0.322799 | 434.8
CNX SERVICE | [NAME] | EQ | [NAME] (INDIA) LTD | 1268477400 | 0.354112 | 332.55
CNX SERVICE | HCLTECH | EQ | HCL TECHNOLOGIES LTD | 694931380 | 0.378712 | 791.55
CNX SERVICE | HDFC | EQ | HDFC LTD | 1543106360 | 1 | 814.1
CNX SERVICE | HDFCBANK | EQ | HDFC BANK LTD | 2375100145 | 0.770608 | 649.25
CNX SERVICE | ICICIBANK | EQ | ICICI BANK LTD. | 1153234650 | 1 | 1110.65
CNX SERVICE | IDEA | EQ | IDEA CELLULAR LIMITED | 3313505065 | 0.241875 | 114.1
CNX SERVICE | IDFC | EQ | IDFC LIMITED | 1514727629 | 0.816162 | 156.25
CNX SERVICE | INDHOTEL | EQ | THE INDIAN HOTELS CO. LTD | 807472787 | 0.624673 | 58.7
CNX SERVICE | INDUSINDBK | EQ | INDUSIND BANK LIMITED | 522370940 | 0.79888 | 431.15
CNX SERVICE | INFY | EQ | INFOSYS LIMITED | 574236166 | 0.839639 | 2874.1
CNX SERVICE | KOTAKBANK | EQ | KOTAK MAHINDRA BANK LTD | 745407328 | 0.504857 | 658.25
CNX SERVICE | NTPC | EQ | NTPC LTD | 8245464400 | 0.25 | 146.85
CNX SERVICE | PNB | EQ | PUNJAB NATIONAL BANK | 339178683 | 0.392304 | 796.7
CNX SERVICE | POWERGRID | EQ | POWER GRID CORP. LTD. | 4629725353 | 0.305785 | 109.65
CNX SERVICE | RCOM | EQ | RELIANCE COMMUNICATIONS L | 2064026881 | 0.321371 | 68.15
CNX SERVICE | RECLTD | EQ | RURAL ELEC CORP. LTD. | 987459000 | 0.332016 | 223.1
CNX SERVICE | RELCAPITAL | EQ | RELIANCE CAPITAL LTD | 245632800 | 0.458614 | 376
CNX SERVICE | [NAME] | EQ | RELIANCE INFRASTRUCTU LTD | 262990000 | 0.514708 | 430.05
CNX SERVICE | RPOWER | EQ | RELIANCE POWER LTD. | 2805126466 | 0.25 | 75.35
CNX SERVICE | SBIN | EQ | STATE BANK OF INDIA | 671045274 | 0.384166 | 2255.05
CNX SERVICE | SRTRANSFIN | EQ | SHRIRAM TRANSPORT FIN CO. | 226854936 | 0.742114 | 684.65
CNX SERVICE | TATAPOWER | EQ | TATA POWER CO LTD | 2373072360 | 0.682463 | 100.7
CNX SERVICE | TCS | EQ | TATA CONSULTANCY SERV LT | 1957220996 | 0.260397 | 1567.7
CNX SERVICE | WIPRO | EQ | WIPRO LTD | 2462818555 | 0.211751 | 438.5
CNX SERVICE | ZEEL | EQ | ZEE ENTERTAINMENT ENT LTD | 953957720 | 0.566327 | 213.55