Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
KuntalSingh
Helper V
Helper V

Need to find PO number from one sheet2 to sheet1

‎10-27-2023 12:16 AM

I have two sheet I need to remove duplicate PO number from sheet2 and find PO number from sheet2 to sheet1 column of PO number in sheet 1 is not fixed it can be in any column also it can be in more than one column I need all the column matched and write that PO number againt match line in custom column

Sheet 2

PO number
29271883
28708911
29196711
29300802
29300802
29259147
26271952
26413668
28308659
29251664
29317287
29306467
29306760
29296795
29301385
29201500
29299888
29274092
29318852
29304456
29304456
29305922
29315112
29305266
29219409
29291274
28743595
29301832
27295453
27030164
29294785
29213672
29251397
29251397
29240616
26959500
28249726
29304419
29215661
29295354
27664330
28626409
29209000
29295275
29275565
29294938
29287337
29066600
29254633
29254633
29212690
29287171
29212690
29272001
29212690
28701549
29176737
26376304
28427167
25933159
29211489
29268136
29254633
29244899
26405854
28626893
28751674
29254967
29253793
28800627
27536705
29222952
29222671
29193137
28557321
29181716
28732144
29233654
29142480
28697711
28695595
26772088
28872261
26202941
28858321
29062648
28669909

Sheet1

AssignmentSupplierDocument NumberAmount in local currencyTextInvoice Num.Document DateDocument Header TextPurchasing Document
26713058132298004300002721########26713058_BALANCE PRD HOLD 13-07-202395  PRD & 100  GST RLZ26713058
0704159492740119358507800000145########NA 22-03-2023E Pay. Portal 
IMPS124912124088132521074300008530########PPMC PWH PT 21 22 08IMPS12491212408806-09-2021PPMC/PWH/PT/21 22/08 
00514420101098961000781########6192     LPG ENGG/SEDE17-02-202301177GPGE2304702 
00509477102215861000019########6247     CONTRACT CELL0010041933/EMDE18-03-20230024NDLG00363123 
00509477102215861000099########6315     CONTRACT CELL0010042766/SEDE12-05-20230024NDLG00050524 
00509477102215861000382########6440     CONTRACT CELL0010041933/PEBG19-07-20230024NDLG00128824 
00509477102215861000391########6469     CONTRACT CELL0010042766/PEBG14-08-20230024NDLG00156724 
00512296102461741000410########6475     LPG OPS/SEDE29-08-20230037BGR0003420 
LPG OPS102461747800001051########SD   SUPPLY OF 5 Kg LPG CYLS CONTRACT NO.1003248434721-01-2020MAHAVEER CYLINDERS 
6641219778533102461747800001685########SECURITY DEPOSIT AGAINST TENDER NO LPG O M PT 06 2 30-05-2022E Pay. Portal 
LPG OPS102461747800002729########SD   LPG O M PT 04 2020 2135731-01-2021MAHAVEER CYLS LTD 
7026083589517102461747800003955########SECURITY DEPOSIT AGAINST TENDER NO. LPG O PT 03 21 03-02-2022E Pay. Portal 
IB102923957800001500########SD   HCC  293  IB 01  PT 90  2020 21 09-09-2021TIKI TAR INDUSTRIES 
00504094119629351000571########6072     RETAIL SALES0010029224/SEDE13-12-2022IGT2201710 
0026484766/00000119629358350330350########3  SD0100 VIM07-07-2022Internet Pmnt 0011962935 
00030588132258681000080########5758     ENGG & PROJECTS0010037891/SEDE25-04-20220607022BG0000259 
LUBES132529467800000527########SD & SPG   HCC 40 LUBES 73 PT 177 2020 21 03-06-20210013252946 
LUBES132529467800000760########SD & SPG   HCC LUBES 69 PT 165 2020  21 25-06-20210013252946 
00512296132819371000549########6496     LPG MATERIALS/SEDE30-08-202330680IGL0000120 
00510371110378321000481########LPG BULK TT NR/SEDE13-02-2020007BG01191150002 
00028001119351321000031########26044826   RCC NR LPG S&D PT 172 2017 18/SEDE24-07-2019INBG03619000062 
0028869897/00000119358508350004834########SD   3 VIM05-06-2023Internet Pmnt 0011935850 
0028949843/00000119358508350006581########SD 10 VIM03-07-2023Internet Pmnt 0011935850 
0029073480/00010119358508350010019########SD DED  23729   10 VIM10-08-2023Internet Pmnt 0011935850 
0029091642/00010119358508350010114-8,047.008047   SD DED 10  VIM14-08-2023Internet Pmnt 0011935850 
0029201439/00000119358508350013851########29201439 SD 10  OF RAVIM28-09-2023Internet Pmnt 0011935850 
0029262641/00000119358508350014889-8,739.508739.45   SD DED 10 VIM12-10-2023Internet Pmnt 0011935850 
0028283548/00000119358508350016466-467.00PRD   0.5 VIM11-11-2022Internet Pmnt 0011935850 
0028400580/00000119358508350019064-6,793.62SD  3 VIM20-12-2022Internet Pmnt 0011935850 
0028939747/00000119799848350006069-6,325.29SECURITY DEPOSITVIM27-06-2023Internet Pmnt 0011979984 
0028939747/00000119799848350006069-1,133.19SECURITY DEPOSITVIM27-06-2023Internet Pmnt 0011979984 
0028939747/00000119799848350006069-1,228.77SECURITY DEPOSITVIM27-06-2023Internet Pmnt 0011979984 
0028292690/00000119799848350016572-150.003  SDVIM14-11-2022Internet Pmnt 0011979984 
0028292690/00000119799848350016572-540.003  SDVIM14-11-2022Internet Pmnt 0011979984 
0028292690/00000119799848350016572-660.003  SDVIM14-11-2022Internet Pmnt 0011979984 
0028292690/00000119799848350016864########SD   3 VIM17-11-2022Internet Pmnt 0011979984 
00705714119801481000022########GEM 2021 B 1109570 CONTRCT NO.GEMC 5116877397449670027042053/PEBG11-06-2021027GT10211600002 
00705714119801481000023########OK0028336110/PEBG22-11-2022027GT10223190001 
0028312337/00000119801488350017306-61.00PRD FOR DELAY 1 DAY .5  WEEK, INV 209VIM24-11-2022Internet Pmnt 0011980148 
10106541101065417800000122########security deposit tender no rcc nr dso eng pt96510-04-201910106541 
 101065417800000967########security deposit capex dso eng pt 885720-06-201910106541 
0028437026/00000101065418350000821-5,168.001 YR SDVIM05-04-2023Internet Pmnt 0010106541 
0028311661/00000101065418350003194-3,643.001 YR SDVIM11-04-2023Internet Pmnt 0010106541 
0028311661/00000101065418350005469########SD  3  RS 28576 PO 28311661VIM20-04-2023Internet Pmnt 0010106541 
1100101077744100104604########EMD for cancelled tender id 2019_DLSO_96296_1110011-02-2020EMD for Tender No 
 101077747800000093########security deposit for rcc nr dso eng pt 361007-04-201710107774 
 101077747800001022########security deposit capex dso eng pt 886026-06-201910107774 
5398697240325101077747800001449########ISD FOR DELHI DO CAT 1 21-02-2023E Pay. Portal 
8468877546723101077747800001450########ISD FOR GURGAON DO CAT 1 21-02-2023E Pay. Portal 
0029064080/00000101077748350038293########ISD DETAIL NOT MAINTAIN   TENDER NO. WITH DO NAMEVIM10-08-2023Internet Pmnt 0010107774 
0029067237/00000101077748350044442-646.12PRD DEDUCTED FOR 1 WEEK DELAYVIM06-09-2023Internet Pmnt 0010107774 
0028109652/00000101077748350046492-513.00PRD FOR DELAY OF 1 WEEK  0.5  OF PO VALUEVIM-110023-09-2022Internet Pmnt 0010107774 
0029162641/00000101077748350047079########RCC NR DSO ENG PT 70 2022 23_12028962 ISD CAT 1VIM13-09-2023Internet Pmnt 0010107774 
0029201444/00000101077748350051632-208.51PRD FOR 1 WEEK DELAYVIM03-10-2023Internet Pmnt 0010107774 
0028414900/00000101077748350095197-1,345.97PRD 2  OF DELIVER VALUEVIM21-03-2023Internet Pmnt 0010107774 
1140101098967800000423########AMC1030-04-20190010109896 
0025933159/00000101098968350049836-667.37SDVIM26-09-2023Internet Pmnt 0010109896 
1100101264424300002626-5,900.00EMD TO BE CONV. TO  SD110020-06-2016EMD TO BE CONV.TO SD 
1726 COLL101969564100022176########ISD Capex Cat  I Contract no 12029044 Delhi DO110022-02-20231726 COLL 
 101969567800000183########security deposit capex loa rcc nr dso eng pt0361512-04-201710196956 
0028292112/00000102608354300054914-1,203.00SDRECOVERY ADJ.12-12-2022Rec. Adj. YF51_VIM 
1002922962615102608357800000150########DSO PT 85  Panipat DO 11-05-2023E Pay. Portal 
0752696019515102608357800000155########DSO PT 85 HISAR DO 12-05-2023E Pay. Portal 
0028173839/00000102608358350000749-1,196.15SD 2 VIM05-04-2023Internet Pmnt 0010260835 
0028413837/00050102608358350018905-246.50SD   3 VIM01-06-2023Internet Pmnt 0010260835 
0028413837/00040102608358350018905-1,085.51SD   3 VIM01-06-2023Internet Pmnt 0010260835 
0028876344/00000102608358350018905-6,739.00PRD   0.5  FOR  6 WEEK DELAYVIM01-06-2023Internet Pmnt 0010260835 
0028876344/00000102608358350018905-4,492.65Automatic SD Recovery   ServiceVIM01-06-2023Internet Pmnt 0010260835 
0028413837/00060102608358350022727-1,740.00SD   3 VIM14-06-2023Internet Pmnt 0010260835 
0028173839/00000102608358350023103-9,891.14PRD FOR 2 WEEKS DELAYVIM16-06-2023Internet Pmnt 0010260835 
0028173839/00000102608358350023103########Automatic SD Recovery   ServiceVIM16-06-2023Internet Pmnt 0010260835 
0028413837/00080102608358350035818-348.84SD   3 VIM03-08-2023Internet Pmnt 0010260835 
0028413837/00090102608358350035818-138.24SD   3 VIM03-08-2023Internet Pmnt 0010260835 
0028413837/00080102608358350035818-340.62SD   3 VIM03-08-2023Internet Pmnt 0010260835 
0028413837/00090102608358350035818-138.24SD   3 VIM03-08-2023Internet Pmnt 0010260835 
0028413837/00090102608358350035818-276.48SD   3 VIM03-08-2023Internet Pmnt 0010260835 
0028413837/00080102608358350035818-748.98SD   3 VIM03-08-2023Internet Pmnt 0010260835 
0028413837/00080102608358350035818-705.88SD   3 VIM03-08-2023Internet Pmnt 0010260835 
Labels:
Message 1 of 4
419 Views
0
3 REPLIES 3
KuntalSingh
Helper V
Helper V

‎10-30-2023 12:08 AM

I am trying to find PO number from Merged column Can some please help

let
Source = Excel.Workbook(File.Contents("C:\Users\\Documents\Copy of EXPORT 2.xlsx"), null, true),
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Assignment", type text}, {"Supplier", Int64.Type}, {"Posting Date", type date}, {"Document Number", Int64.Type}, {"Special G/L ind.", type text}, {"Amount in local currency", type number}, {"Text", type text}, {"Invoice Num.", type text}, {"Document Date", type date}, {"Clearing Document", type text}, {"Document Header Text", type text}, {"User Name", type text}, {"Local Currency", type text}, {"Net due date", type date}, {"Purchasing Document", Int64.Type}, {"Entry Date", type date}, {"Time of Entry", type datetime}}),
#"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Changed Type", {{"Document Number", type text}, {"Purchasing Document", type text}}, "en-IN"),{"Assignment", "Document Number", "Text", "Invoice Num.", "Document Header Text", "Purchasing Document"},Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"Merged"),
#"Reordered Columns" = Table.ReorderColumns(#"Merged Columns",{"Supplier", "Posting Date", "Special G/L ind.", "Amount in local currency", "Document Date", "Clearing Document", "User Name", "Local Currency", "Net due date", "Entry Date", "Time of Entry", "Merged"}),
#"Appended Query" = Table.Combine({#"Reordered Columns", #"Sheet1 (2)"})
in
#"Appended Query"

SupplierPosting DateSpecial G/L ind.Amount in local currencyDocument DateClearing DocumentUser NameLocal CurrencyNet due dateEntry DateTime of EntryMergedPurchasing Document
1021129211-09-2023891544.4828-07-2023 B2BPRDINR28-07-202311-09-202331-12-1899 14:56:530028562105 4300009482 354541434/31.07.2023 2859060202314520 72859060202314520 2856210529321565
1010339113-09-202371174679420-05-2023 WF-BATCHINR20-05-202313-09-202331-12-1899 10:45:08 4300009543 CLAIMING -5% ADVANCE AGAINST APPROVAL OF DRAWINGS( 1809/001/2023-24 1809/001/2023-24 2849065329300685
1010339106-10-202372.02E+0822-09-2023 00083216INR22-09-202306-10-202331-12-1899 15:55:5028468654 1100035326 70% of LSC 328 Inv P/23-24/54 P/23-24/54/  2846865429321485
1010339121-08-202361148333108-08-2023 WF-BATCHINR08-08-202321-08-202331-12-1899 14:44:58 4300008809 CLAIMING 5% ADVANCE AGAINST APPROVAL OF DRAWINGS(I 1808/001/2023-24 1808/001/2023-24 2846865429321519
1193211724-03-2023A5449363716-03-2023 WF-BATCHINR16-03-202324-03-202331-12-1899 14:50:54 4300155161 GENERAL CONSTRUCITON WORK 005 005 2836512129280131
1010339107-08-2023630870018-03-2023 WF-BATCHINR18-03-202307-08-202331-12-1899 12:24:19 4300007834 AIMING -5% ADVANCE AGA

ND AGAINST SUBMISSION OF 1779/001/2022-23 1779/001/2022-23 28106065		29313273
1322980013-07-2023)-84220213-07-2023 00509151INR13-07-202313-07-202331-12-1899 15:16:3026713058 4300002721 26713058_BALANCE PRD HOLD  95% PRD & 100% GST RLZ 2671305829311200
1193211705-11-2012)-2E+0705-11-2012 00501760INR05-11-201205-11-201231-12-1899 15:45:07PRICE DISCOUNT 4300000118 PRICE DISCOUNT_10%_FINAL BILL_ 23329315 FINAL BILL FINAL BILL_23329315 2332931529313535
1193585022-03-2023*-5876022-03-2023 FI_BKGINR22-03-202322-03-202331-12-1899 21:23:120704159492740 7800000145 NA  E-Pay. Portal 29318369
1325210706-09-2021*-1040006-09-2021 00044480INR31-12-202311-09-202131-12-1899 09:44:55IMPS124912124088 4300008530 PPMC/PWH/PT/21-22/08 IMPS124912124088 PPMC/PWH/PT/21-22/08 28490534
1010989614-03-2023C-10000017-02-2023 00010877INR13-10-202314-03-202331-12-1899 16:51:0400514420 1000781 6192  -  LPG ENGG /SEDE 01177GPGE2304702 28589270
1022158618-04-2023C-10000018-03-2023 00010877INR01-10-202318-04-202331-12-1899 15:16:4200509477 1000019 6247  -  CONTRACT CELL 0010041933/EMDE 0024NDLG00363123 28493632
1022158629-05-2023C-10000012-05-2023 00010877INR30-11-202329-05-202331-12-1899 15:34:2400509477 1000099 6315  -  CONTRACT CELL 0010042766/SEDE 0024NDLG00050524 29307330
1022158617-08-2023C-221500019-07-2023 00010877INR30-07-202517-08-202331-12-1899 16:42:3800509477 1000382 6440  -  CONTRACT CELL 0010041933/PEBG 0024NDLG00128824 29315132
1022158621-08-2023C-266600014-08-2023 00010877INR02-09-202521-08-202331-12-1899 16:41:0700509477 1000391 6469  -  CONTRACT CELL 0010042766/PEBG 0024NDLG00156724 29308958
1024617431-08-2023C-100000029-08-2023 00010877INR31-12-202531-08-202331-12-1899 12:30:5300512296 1000410 6475  -  LPG OPS /SEDE 0037BGR0003420 29323239
1024617421-01-2020D-50000021-01-2020 00010877INR11-02-202521-01-202031-12-1899 10:05:51LPG OPS 7800001051 SD - SUPPLY OF 5 Kg LPG CYLS CONTRACT NO.10032484 347 MAHAVEER CYLINDERS 29322500
1024617430-05-2022D-40000030-05-2022 FI_BKGINR01-06-202530-05-202231-12-1899 11:15:166641219778533 7800001685 SECURITY DEPOSIT AGAINST TENDER NO LPG O M PT 06 2  E-Pay. Portal 29325064
1024617431-01-2021D-25000031-01-2021 00010877INR31-03-202431-01-202131-12-1899 15:28:58LPG OPS 7800002729 SD - LPG-O/M/PT-04/2020-21 357 MAHAVEER CYLS LTD 29325071
1024617403-02-2022D-30100003-02-2022 FI_BKGINR11-02-202503-02-202231-12-1899 12:27:557026083589517 7800003955 SECURITY DEPOSIT AGAINST TENDER NO. LPG-O/PT-03/21  E-Pay. Portal 29325075
1029239509-09-2021D-10000009-09-2021 00010877INR15-10-202108-10-202131-12-1899 16:38:41IB 7800001500 SD - HCC/ 293 /IB-01 /PT-90 /2020-21  TIKI TAR INDUSTRIES 29324040
1193211716-05-2016~-95088.216-05-2016 00032979INR10-05-201616-05-201631-12-1899 14:33:230023453852/00000 8350009131 RECOVERY_PO 23453852_IO 100468 PARADEEP IO-1000468-32RA Internet Pmnt-0011932117 28215298
1193211724-11-2015~-10573524-11-2015 00032979INR23-11-201524-11-201531-12-1899 10:46:165300011685/001/~ 8350045455 AGNT LINE 30, 60 & 90_PO 23408428_IO 1000468 IO-1000468-23 RA Internet Pmnt-0011932117 29288348
1196293514-12-2022C-2E+0713-12-2022 00010877INR31-05-202414-12-202231-12-1899 16:20:4100504094 1000571 6072  -  RETAIL SALES 0010029224/SEDE IGT2201710 29314359
1196293507-07-2022E-55760207-07-2022 00083214INR30-04-202307-07-202231-12-1899 17:40:210026484766/00000 8350330350 3% SD 0100 VIM Internet Pmnt-0011962935 29314553
1322586829-04-2022C-104805025-04-2022 00010877INR31-03-202429-04-202231-12-1899 16:32:2300030588 1000080 5758  -  ENGG & PROJECTS 0010037891/SEDE 0607022BG0000259 29271883
1325294603-06-2021D-30000003-06-2021 00010877INR03-12-202203-06-202131-12-1899 17:15:38LUBES 7800000527 SD & SPG - HCC/40/LUBES-73/PT-177/2020-21  0013252946 29322912
1325294625-06-2021D-30000025-06-2021 00010877INR24-12-202225-06-202131-12-1899 16:31:22LUBES 7800000760 SD & SPG - HCC/LUBES-69/PT-165/2020- 21  0013252946 29325428
1328193713-10-2023C-100000030-08-2023 00010877INR31-12-202513-10-202331-12-1899 14:36:5300512296 1000549 6496  -  LPG MATERIALS /SEDE 30680IGL0000120 29321583
1103783217-02-2020C-75000013-02-2020 00019968INR28-02-202617-02-202031-12-1899 16:25:0300510371 1000481 LPG/BULK/TT/NR /SEDE 007BG01191150002 29321600
1193513202-05-2019C-318237024-07-2019 00513593INR30-11-202402-05-201931-12-1899 11:35:2900028001 1000031 26044826 - RCC/NR/LPG-S&D/PT-172/2017-18 /SEDE INBG03619000062 29325251
1193585005-06-2023E-13707.105-06-2023 00040389INR31-12-202305-06-202331-12-1899 09:48:480028869897/00000 8350004834 SD @ 3% VIM Internet Pmnt-0011935850 29195971
1193585003-07-2023E-2792003-07-2023 00083152INR15-11-202303-07-202331-12-1899 10:55:490028949843/00000 8350006581 SD@10% VIM Internet Pmnt-0011935850 29149468
1193585010-08-2023*-2372910-08-2023 00040389INR08-08-202410-08-202331-12-1899 09:27:580029073480/00010 8350010019 SD DED  23729/- 10% VIM Internet Pmnt-0011935850 26330191
1193585014-08-2023*-804714-08-2023 00083152INR10-08-202414-08-202331-12-1899 10:21:470029091642/00010 8350010114 8047/- SD DED 10%@ VIM Internet Pmnt-0011935850 29324510
1193585028-09-2023E-47236.628-09-2023 00040389INR02-05-202528-09-202331-12-1899 09:32:330029201439/00000 8350013851 29201439 SD@10% OF RA VIM Internet Pmnt-0011935850 29324341
1193585012-10-2023*-8739.512-10-2023 00040389INR11-10-202412-10-202331-12-1899 14:07:330029262641/00000 8350014889 8739.45/- SD DED 10% VIM Internet Pmnt-0011935850 29295194
1193585011-11-2022)-46711-11-2022 00083152INR11-11-202211-11-202231-12-1899 16:01:240028283548/00000 8350016466 PRD @ 0.5% VIM Internet Pmnt-0011935850 29264185
1193585020-12-2022E-6793.6220-12-2022 00083152INR11-12-202320-12-202231-12-1899 12:40:150028400580/00000 8350019064 SD @3% VIM Internet Pmnt-0011935850 29297239
1197998427-06-2023E-6325.2927-06-2023 00033174INR25-06-202427-06-202331-12-1899 11:00:380028939747/00000 8350006069 SECURITY DEPOSIT VIM Internet Pmnt-0011979984 29297227
1197998427-06-2023E-1133.1927-06-2023 00033174INR25-06-202427-06-202331-12-1899 11:00:380028939747/00000 8350006069 SECURITY DEPOSIT VIM Internet Pmnt-0011979984 26891013
1197998427-06-2023E-1228.7727-06-2023 00033174INR25-06-202427-06-202331-12-1899 11:00:380028939747/00000 8350006069 SECURITY DEPOSIT VIM Internet Pmnt-0011979984 29187806
1197998414-11-2022E-15014-11-2022 00101046INR11-11-202314-11-202231-12-1899 12:16:360028292690/00000 8350016572 3% SD VIM Internet Pmnt-0011979984 28468618
1197998414-11-2022E-54014-11-2022 00101046INR11-11-202314-11-202231-12-1899 12:16:360028292690/00000 8350016572 3% SD VIM Internet Pmnt-0011979984 29319312
1197998414-11-2022E-66014-11-2022 00101046INR11-11-202314-11-202231-12-1899 12:16:360028292690/00000 8350016572 3% SD VIM Internet Pmnt-0011979984 29319324
1197998417-11-2022E-2145017-11-2022 00083214INR30-11-202317-11-202231-12-1899 11:33:200028292690/00000 8350016864 SD @ 3% VIM Internet Pmnt-0011979984 29319347
1198014815-07-2021C-3339011-06-2021 00030032INR01-09-202415-07-202131-12-1899 14:23:2800705714 1000022 GEM/2021/B/1109570 CONTRCT NO.GEMC-511687739744967 0027042053/PEBG 027GT10211600002 29299501
1198014805-12-2022C-4431022-11-2022 00028427INR04-11-202305-12-202231-12-1899 12:14:0200705714 1000023 OK 0028336110/PEBG 027GT10223190001 28636490
1198014824-11-2022)-6124-11-2022 00033174INR24-11-202224-11-202231-12-1899 12:42:490028312337/00000 8350017306 PRD FOR DELAY 1 DAY@.5%/WEEK, INV 209 VIM Internet Pmnt-0011980148 28945222
Message 4 of 4
361 Views
0
_elbpower
Resolver III
Resolver III

‎10-27-2023 01:13 AM

  1. In Sheet1, create a new column called "Custom Column."

  2. Copy the PO numbers from Sheet2 and paste them into the "Custom Column" in Sheet1.

  3. Remove any duplicate PO numbers in the "Custom Column" using Excel's "Remove Duplicates" feature. To do this, select the "Custom Column," go to the "Data" tab, click on "Remove Duplicates," ensure only the "Custom Column" is selected in the dialog box, and click "OK."

  4. With a list of unique PO numbers in the "Custom Column" of Sheet1, you can now search for these numbers in other columns of Sheet1 using the "VLOOKUP" function.

  5. Create a new column (or multiple columns if the PO numbers may be in different columns) next to the "Custom Column" in Sheet1.

  6. In the first cell of the new column, use this formula (assuming the PO number is in column B and your unique PO number in the "Custom Column" is in column D):

    excelCopy code
    =IFERROR(VLOOKUP(D2, B:B, 1, FALSE), "")

    This formula will look for a match of the PO number in the "Custom Column" (D2) within column B of Sheet1. If a match is found, it will display the PO number; otherwise, it will show an empty cell.

  7. Copy this formula down to apply it to all the rows in the new column(s). This will check for matches of the PO numbers in different columns of Sheet1.

  8. If the PO numbers can be in multiple columns, you may need to repeat the process for each potential column where the PO number could be located.

Message 2 of 4
391 Views
0
KuntalSingh
Helper V
Helper V
In response to _elbpower

‎10-27-2023 02:16 AM

This souliotn is not work. Because PO number in other colums are not in standard formate for example this is PO number in sheet 2 

29219409

 when I search this PO in sheet 2 it find in column name Invoice no as 

0029219409_SEDE
Message 3 of 4
386 Views
0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

View All