Spreadsheet: 834212d1687528050-find-text-in-row-and-get-the-value-where-if-match-sample
Sheet: Sheet1

RESULT | PRODUCT | PP | turnover | seller | A
Financial Approval Detail| वीयवीकृ तववरणPaying Authority Details|भगताना धकरणववरण IFD Concurrence|आईएफडी सहम त :NoRole:PAO Designation of Administrative Approval|Payment Mode| GM-2/Civil/RKSHOffline शास नक अनमोदन का पदनाम:भगतान [NAME] तरीका: Designation of Financial Approval|Designation|पद :DGM DS JGM/FIN/RKSH वीय अनमोदन [NAME] :[NAME] ID|ईमल आईडी :[EMAIL] GSTIN|जीएसट आईएन :05AACCR5652A1ZT Rail Vikas Nigam Limited, OFFICE BUILDING, Oppo GST Address|पता:BHAWAN, NEXT TO GMVN, SHYAMPUR BYPASS ROAD, Dehradun, UTTARAKHAND-249201, India | 18063135194 | 15750 | Rs.132,985,712.00 | Financial Approval Detail| वीयवीकृ तववरणPaying Authority Details|भगताना धकरणववरण IFD Concurrence|आईएफडी सहम त :NoRole:PAO Designation of Administrative Approval|Payment Mode| GM-2/Civil/RKSHOffline शास नक अनमोदन का पदनाम:भगतान [NAME] तरीका: Designation of Financial Approval|Designation|पद :DGM DS JGM/FIN/RKSH वीय अनमोदन [NAME] :[NAME] ID|ईमल आईडी :[EMAIL] GSTIN|जीएसट आईएन :05AACCR5652A1ZT Rail Vikas Nigam Limited, OFFICE BUILDING, Oppo GST Address|पता:BHAWAN, NEXT TO GMVN, SHYAMPUR BYPASS ROAD, Dehradun, UTTARAKHAND-249201, India | A14 Bionic | iPhone 12
Financial Approval Detail| वीयवीकृ तववरणPaying Authority Details|भगताना धकरणववरण IFD Concurrence|आईएफडी सहम त :NoRole:PAO Designation of Administrative Approval|Payment Mode| CPM(Co-Ord.)Offline शास नक अनमोदन का पदनाम:भगतान [NAME] तरीका: Designation of Financial Approval|Designation|पद :SR MANAGER PSA Sr.Manager/Finance वीय अनमोदन [NAME] :[NAME] ID|ईमल आईडी :[EMAIL] GSTIN|जीएसट आईएन :33AACCR5652A1ZU MEZZANINE FLOOR,TIRUMAILAI RAILWAY STATION , Address|पता:MYLAPORE, Chennai, TAMIL NADU-600004, India | 18063135194 | Financial Approval Detail| वीयवीकृ तववरणPaying Authority Details|भगताना धकरणववरण IFD Concurrence|आईएफडी सहम त :NoRole:PAO Designation of Administrative Approval|Payment Mode| CPM(Co-Ord.)Offline शास नक अनमोदन का पदनाम:भगतान [NAME] तरीका: Designation of Financial Approval|Designation|पद :SR MANAGER PSA Sr.Manager/Finance वीय अनमोदन [NAME] :[NAME] ID|ईमल आईडी :[EMAIL] GSTIN|जीएसट आईएन :33AACCR5652A1ZU MEZZANINE FLOOR,TIRUMAILAI RAILWAY STATION , Address|पता:MYLAPORE, Chennai, TAMIL NADU-600004, India | [NAME] | 25 | Snapdragon 888 | [NAME] Pro
Financial Approval Detail| वीयवीकृ तववरणPaying Authority Details|भगताना धकरणववरण IFD Concurrence|आईएफडी सहम त :NoRole:PAO Designation of Administrative Approval|Payment Mode| VCOffline शास नक अनमोदन का पदनाम:भगतान [NAME] तरीका: Designation of Financial Approval|Designation|पद :Assistant Registrar Finance FO वीय अनमोदन [NAME] :[NAME] ID|ईमल आईडी :[EMAIL] GSTIN|जीएसट आईएन :- R. Venkataraman Nagar Pondicherry University, [NAME]:Pondicherry 605014, [NAME], PUDUCHERRY-605014, India | 18063135194 | 1542.22 | [NAME] | Financial Approval Detail| वीयवीकृ तववरणPaying Authority Details|भगताना धकरणववरण IFD Concurrence|आईएफडी सहम त :NoRole:PAO Designation of Administrative Approval|Payment Mode| VCOffline शास नक अनमोदन का पदनाम:भगतान [NAME] तरीका: Designation of Financial Approval|Designation|पद :Assistant Registrar Finance FO वीय अनमोदन [NAME] :[NAME] ID|ईमल आईडी :[EMAIL] GSTIN|जीएसट आईएन :- R. Venkataraman Nagar Pondicherry University, [NAME]:Pondicherry 605014, [NAME], PUDUCHERRY-605014, India | Exynos 2100 | Samsung Galaxy S21
#NA | 18063135194 | 15536.1 | Rs.1,957,991.50 | 18063135194 | Kirin 9000 | [NAME] 40
#NA | 18063135194 | 8485.9 | Rs.335,238.48 | 18063135194 | Dimensity 1200 | Poco F3 GT
Financial Approval Detail| वीयवीकृ तववरणPaying Authority Details|भगताना धकरणववरण IFD Concurrence|आईएफडी सहम त :YesRole:DDO Designation of Administrative Approval|Payment Mode| JOINT COMMISSIONERPFMS शास नक अनमोदन का पदनाम:भगतान [NAME] तरीका: Designation of Financial Approval|Designation|पद :Chief Accounts Officer JOINT COMMISSIONER वीय अनमोदन [NAME] :[NAME] ID|ईमल आईडी :[EMAIL] GSTIN|जीएसट आईएन :- 60, [NAME], Custom House, Chennai - 600 001, Address|पता: Chennai, TAMIL NADU-600001, India | 18063135194 | 8493.95 | Rs.335,238.48 | 18063135194 | Financial Approval Detail| वीयवीकृ तववरणPaying Authority Details|भगताना धकरणववरण IFD Concurrence|आईएफडी सहम त :YesRole:DDO Designation of Administrative Approval|Payment Mode| JOINT COMMISSIONERPFMS शास नक अनमोदन का पदनाम:भगतान [NAME] तरीका: Designation of Financial Approval|Designation|पद :Chief Accounts Officer JOINT COMMISSIONER वीय अनमोदन [NAME] :[NAME] ID|ईमल आईडी :[EMAIL] GSTIN|जीएसट आईएन :- 60, [NAME], Custom House, Chennai - 600 001, Address|पता: Chennai, TAMIL NADU-600001, India | Realme Narzo 30
NOTE
I WANT TO GET THE DATA MARKED IN GREEN AS A RESULT USING THE FORMULA.
SEARCH SPECIFIC  TEXT (Financial Approval Detail) IN ATHE IN ROW AND GET THE FLULL NAME OF THE MATCH VALUE.