Partial Text Lookup

Sufiyan97

Well-known Member
Joined
Apr 12, 2019
Messages
1,538
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
Is it possible to lookup partial text from October file Column B (Description) to November file
I want to lookup Manual Description, Number and Account from October to November file

October.xlsx
ABCDE
2DateDescriptionManual DescriptionNumberAccount
310/1/2020Monthly Fee for Business Advantagebank service fee73100Bank Charges & Fees:Service Charges
410/2/2020CHECKCARD 1001 FBPAY - FUNDRAISE 2312321323 CA 55429500275637189226098 CKCD 8398 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Charitable Contributions74000Charitable Contributions
510/5/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
610/5/2020CHECKCARD 1004 JAF CPA SPRING TX 85500390278900015600858 CKCD 8931 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Accountant68100Legal & Professional Services:Accounting & Bookkeeping Services
710/5/2020CHECKCARD 1003 AMZN MKTP US*MK9P AMZN.COM/BILLWA 55310200277083361873513 CKCD 5942 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Tools51000Cost of Goods Sold:Tools
810/5/2020CHECKCARD 1003 AMZN MKTP US*MK29 AMZN.COM/BILLWA 55310200277083722396733 CKCD 5942 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Tools51000Cost of Goods Sold:Tools
910/6/2020CHECKCARD 1005 ISG/SF 0000023164 5122179880 TX 55429500280637569305036 CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Termite inspection fee56000Cost of Goods Sold:Termite Inspection COS
1010/6/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
1110/6/2020Zelle Transfer Conf# e5c637db1; RAMIREZ, JAMESAmerispec45100Income - Services:Income-Subcontracting:Amerispec
1210/7/2020CHECKCARD 1006 PLUM DIGITAL MARK 8009929663 MA 55429500280637584725671 RECURRING CKCD 5818 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Digital marketing63300Advertising & Marketing:Other Marketing
1310/7/2020CHECKCARD 1006 ISG/SF 0000023175 5122179880 TX 55429500280637620713400 CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Termite inspection fee56000Cost of Goods Sold:Termite Inspection COS
1410/7/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
1510/8/2020CHECKCARD 1007 ACTBLUE*JOE.BIDEN ACTBLUECC.COMMA 75418230281104422321860 CKCD 8651 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Charitable Contributions74000Charitable Contributions
1610/8/2020CHECKCARD 1006 GOIN' POSTAL RICHMOND TX 85428140281980027637968 CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Postage & Shipping72100Office Supplies and Expenses:Postage & Shipping
1710/8/2020CHECKCARD 1007 BLIPP REVIEWS - U 8019950318 UT 55429500282637748332735 RECURRING CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Online review expenses63300Advertising & Marketing:Other Marketing
1810/9/2020CHECKCARD 1009 Freelancer.com London 15265670283000473234942 RECURRING CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Design Expenses63700Advertising & Marketing:Design Expenses
1910/9/2020CHECKCARD 1009 Freelancer.com London 15265670283000480925854 RECURRING CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Design Expenses63700Advertising & Marketing:Design Expenses
2010/9/2020CHECKCARD 1009 Freelancer.com London 15265670283000473234942 RECURRING CKCD 7399 XXXXXXXXXXXX5599 INTERNATIONAL TRANSACTION FEEDesign Expenses63700Advertising & Marketing:Design Expenses
2110/9/2020CHECKCARD 1009 Freelancer.com London 15265670283000480925854 RECURRING CKCD 7399 XXXXXXXXXXXX5599 INTERNATIONAL TRANSACTION FEEDesign Expenses63700Advertising & Marketing:Design Expenses
2210/9/2020Zelle Transfer Conf# XXXXXXXXX; BRC HOME SERVICE LLCIncome41000Income - Services:General Home Inspection
2310/13/2020Online Banking transfer to CHK 3960 Confirmation# 3329869163Drawing32300Owner's Equity:Owner Drawings
2410/13/2020CHECKCARD 1010 FIVERR * 9543682267 NY 55429500284894009413179 CKCD 7299 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Advertising63900New Website SEO
2510/13/2020CHECKCARD 1012 LaunchGood Inc. 8559991947 MI 15270210286427198357440 RECURRING CKCD 8398 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Charitable Contributions74000Charitable Contributions
2610/13/2020CHECKCARD 1010 FIVERR * 9543682267 NY 55429500284894007866915 CKCD 7299 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Advertising63900New Website SEO
2710/13/2020CHECKCARD 1013 Freelancer.com London 15265670286428775574946 RECURRING CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Design Expenses63700Advertising & Marketing:Design Expenses
2810/13/2020CHECKCARD 1013 CRAIGSLIST.ORG 415-399-5200 CA 55432860287200807321848 CKCD 5969 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Advertising63300Advertising & Marketing:Other Marketing
2910/13/2020CHECKCARD 1013 Freelancer.com London 15265670286431298468729 RECURRING CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Design Expenses63700Advertising & Marketing:Design Expenses
3010/13/2020CHECKCARD 1013 Freelancer.com London 15265670286428775574946 RECURRING CKCD 7399 XXXXXXXXXXXX5599 INTERNATIONAL TRANSACTION FEEDesign Expenses63700Advertising & Marketing:Design Expenses
3110/13/2020CHECKCARD 1013 Freelancer.com London 15265670286431298468729 RECURRING CKCD 7399 XXXXXXXXXXXX5599 INTERNATIONAL TRANSACTION FEEDesign Expenses63700Advertising & Marketing:Design Expenses
3210/13/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
3310/14/2020BARCLAYCARD US DES:CREDITCARD ID:XXXXXXXXX INDN:HABIB OTHMAN CO ID:2510407970 WEBcomputer22300Other Current Liabilities:Loan-Computer Finance
3410/14/2020CHECKCARD 1013 ISG/SF 0000023423 5122179880 TX 55429500287637235846309 CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Termite inspection fee56000Cost of Goods Sold:Termite Inspection COS
3510/14/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
3610/16/2020WELLS FARGO AUTO DES:DRAFT ID:510660015508 INDN:HABIB,,OTHMAN CO ID:0122287170 PPDTruck27100Notes Payable:Loan-2017 Honda Ridgeline Financing
3710/16/2020CHECKCARD 1015 ISN/CI 8007008112 NV 55506290289726680580455 CKCD 7372 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599ISN65600Communication and Technology:Software Expense
3810/16/2020WELLS FARGO AUTO DES:DRAFT ID:510660015508 INDN:HABIB,,OTHMAN CO ID:0122287170 PPDInterest77100Interest Paid:Vehicle Financing
3910/16/2020CHECKCARD 1016 SAMS CLUB #470 FRIENDSWOOD TX CKCD 5542 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599gas62200Vehicle Expenses:Fuel and Gasoline
4010/19/2020IPFS866-412-1793 DES:IPFSPMTAZP ID:413868 INDN:BULLS EYE HOME INSPECT CO ID:0131659615 CCDE&O insurance67300Insurance:Liability and E&O insurance
4110/19/2020Zelle Transfer Conf# 0d49e8d0f; RAMIREZ, JAMESAmerispec45100Income - Services:Income-Subcontracting:Amerispec
4210/20/2020Online Banking transfer to CHK 3960 Confirmation# 2221847077Drawing32300Owner's Equity:Owner Drawings
4310/20/2020HCTRA EFT DES:EZTAGSTCCD ID:XXXXXXXXX INDN:HABIB OTHMAN CO ID:2746019451 CCDTolls69100Travel:Tolls and Parking
4410/21/2020CHECKCARD 1021 HOME INSPECTOR PR 8887504777 CA 75187420295000000914474 CKCD 1799 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599software icloud monthly fee65600Communication and Technology:Software Expense
4510/21/2020BKOFAMERICA MOBILE 10/21 3823045254 DEPOSIT *MOBILE TXIncome41000Income - Services:General Home Inspection
4610/21/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
4710/22/2020PAYPAL DES:INST XFER ID:ASTRINGER INDN:HABIB OTHMAN CO ID:PAYPALSI77 WEBMarketing on Facebook63800Advertising & Marketing:Facebook
4810/22/2020CHECKCARD 1022 SAMSCLUB #6867 RICHMOND TX CKCD 5542 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599gas62200Vehicle Expenses:Fuel and Gasoline
4910/22/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
5010/23/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
5110/26/2020AscentiumCapital DES:LEASECHG ID:141994 INDN:BULLSEYE HOME INSPECTI CO ID:9176794002 CCDEquipment lease for another business66100Equipment Lease
5210/26/2020AMZ_STORECRD_PMT DES:PAYMENT ID:604578112099349 INDN: 6045781120993497 CO ID:9069872000 PPDequipment70100Education and Training Expenses:Equipment Training
5310/26/2020CHECKCARD 1023 INTER NACHI BOULDER CO 25247800297002827050858 RECURRING CKCD 8699 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599membership82300Licenses/Permit/Dues/Subscriptions:Dues & subscriptions
5410/26/2020CHECKCARD 1023 FREEDOM VOICE SYS 800-4771477 CA 75418230297105516977345 RECURRING CKCD 4814 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599virtual phone number65100Communication and Technology:Cell Phone Expenses
5510/26/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
5610/26/2020Zelle Transfer Conf# 79988b950; RAMIREZ, JAMESAmerispec45100Income - Services:Income-Subcontracting:Amerispec
5710/27/2020CHECKCARD 1026 ISG/SF 0000023837 5122179880 TX 55429500301637417535359 CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Termite inspection fee56000Cost of Goods Sold:Termite Inspection COS
5810/27/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
5910/28/2020CHECKCARD 1028 Freelancer.com London 15265670302000198048723 RECURRING CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Design Expenses63700Advertising & Marketing:Design Expenses
6010/28/2020CHECKCARD 1028 SAMSCLUB #4712 HOUSTON TX CKCD 5542 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599gas62200Vehicle Expenses:Fuel and Gasoline
6110/28/2020CHECKCARD 1027 ISG/SF 0000023854 5122179880 TX 55429500301637471968181 CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Termite inspection fee56000Cost of Goods Sold:Termite Inspection COS
6210/28/2020CHECKCARD 1026 BURGER KING #4396 KATY TX 55431800301400331000889 CKCD 5814 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Meals71500Meals & Entertainment:Business Related Meals
6310/28/2020CHECKCARD 1028 Freelancer.com London 15265670302000199744940 RECURRING CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Design Expenses63700Advertising & Marketing:Design Expenses
6410/28/2020CHECKCARD 1028 Freelancer.com London 15265670302000198048723 RECURRING CKCD 7399 XXXXXXXXXXXX5599 INTERNATIONAL TRANSACTION FEEDesign Expenses63700Advertising & Marketing:Design Expenses
6510/28/2020CHECKCARD 1028 Freelancer.com London 15265670302000199744940 RECURRING CKCD 7399 XXXXXXXXXXXX5599 INTERNATIONAL TRANSACTION FEEDesign Expenses63700Advertising & Marketing:Design Expenses
6610/29/2020CHECKCARD 1028 CHEVRON 0305116 HOUSTON TX 55432860302200822590469 CKCD 5542 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Fuel62200Vehicle Expenses:Fuel and Gasoline
6710/29/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
6810/30/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
Sheet1



November File

November.xlsx
ABCDE
2DateDescriptionManual DescriptionNumberAccount
311/2/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCD
411/3/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCD
511/4/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCD
611/9/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCD
711/9/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCD
811/9/2020Zelle Transfer Conf# 9a90afe1d; RAMIREZ, JAMES
911/12/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCD
1011/16/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCD
1111/16/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCD
1211/16/2020Zelle Transfer Conf# aa02a1a24; RAMIREZ, JAMES
1311/17/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCD
1411/18/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCD
1511/19/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCD
1611/20/2020TRUE PROTECTION, DES:PAYROLL ID:01820000-0381-0 INDN:BULLSEYE HOME INSPECTI CO ID:1462800242 PPD
1711/25/2020INSTITUTEOFTRAN DES:TPCB BILLS ID:Mr Othman INDN:BULLS EYE HOME IN[ CO ID:1530232732 CCD
1811/25/2020Zelle Transfer Conf# bede29bfb; RAMIREZ, JAMES
1911/27/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCD
2011/30/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCD
2111/30/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCD
2211/2/2020Online Banking transfer to CHK 3960 Confirmation# 2218107275
2311/3/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCD
2411/10/2020Online Banking transfer to CHK 3960 Confirmation# 3201130075
2511/13/2020HCTRA EFT DES:EZTAGSTCCD ID:XXXXXXXXX INDN:HABIB OTHMAN CO ID:2746019451 CCD
2611/16/2020WELLS FARGO AUTO DES:DRAFT ID:510660015508 INDN:HABIB,,OTHMAN CO ID:0122287170 PPD
2711/16/2020WELLS FARGO AUTO DES:DRAFT ID:510660015508 INDN:HABIB,,OTHMAN CO ID:0122287170 PPD
2811/16/2020BARCLAYCARD US DES:CREDITCARD ID:XXXXXXXXX INDN:HABIB OTHMAN CO ID:2510407970 WEB
2911/17/2020Online Banking transfer to CHK 3960 Confirmation# 1561834780
3011/17/2020IPFS866-412-1793 DES:IPFSPMTAZP ID:413868 INDN:BULLS EYE HOME INSPECT CO ID:0131659615 CCD
3111/25/2020Online Banking transfer to CHK 7923 Confirmation# 1229015051
3211/25/2020Online Banking transfer to CHK 3960 Confirmation# 2229026532
3311/25/2020AscentiumCapital DES:LEASECHG ID:141994 INDN:BULLSEYE HOME INSPECTI CO ID:9176794002 CCD
3411/25/2020AMZ_STORECRD_PMT DES:PAYMENT ID:604578112099349 INDN: 6045781120993497 CO ID:9069872000 PPD
3511/30/2020Online Banking transfer to CHK 3960 Confirmation# 1270874052
3611/4/2020CHECKCARD 1103 IN *J3 RESOURCES, 713-2900221 TX 55432860308200406920029 CKCD 7392 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
3711/5/2020CHECKCARD 1104 TX BD ENG LIC REN 5124403063 TX 55488720310091332000464 CKCD 9399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
3811/5/2020CHECKCARD 1105 eBay O*02-06012-0 San Jose CA 15270210310001147494941 CKCD 5311 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
3911/6/2020CHECKCARD 1105 GILLMAN HONDA HOUSTON TX 55310200310207098200075 CKCD 5511 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
4011/6/2020CHECKCARD 1105 AMZN MKTP US*289V AMZN.COM/BILLWA 55310200311083703189089 CKCD 5942 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
4111/6/2020CHECKCARD 1106 SAMSCLUB #4712 HOUSTON TX CKCD 5542 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
4211/9/2020CHECKCARD 1106 AMZN MKTP US*287L AMZN.COM/BILLWA 55310200311083360221092 CKCD 5942 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
4311/9/2020CHECKCARD 1107 TST* RUDY S COUNT SPRING TX 02305370312500225745329 CKCD 5812 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
4411/9/2020CHECKCARD 1107 BLIPP REVIEWS - U 8019950318 UT 55429500313637524641450 RECURRING CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
4511/12/2020CHECKCARD 1110 PHO KIM LONG KATY TX 75217690316450000783436 CKCD 5812 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
4611/12/2020CHECKCARD 1110 JAF CPA SPRING TX 85500390315900015700869 CKCD 8931 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
4711/12/2020WAL SAM'S Club 11/11 #000100638 PURCHASE 6867 WAL-SAMS RICHMOND TX
4811/13/2020CHECKCARD 1112 ISN/CI 8007008112 NV 55506290317726497439966 CKCD 7372 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
4911/13/2020CHECKCARD 1113 SAMS CLUB #686 RICHMOND TX CKCD 5542 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
5011/16/2020CHECKCARD 1113 IN *J3 RESOURCES, 713-2900221 TX 55432860318200017052442 CKCD 7392 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
5111/18/2020CHECKCARD 1118 Freelancer.com London 15265670323008236415858 RECURRING CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
5211/18/2020CHECKCARD 1118 Freelancer.com London 15265670323008217068726 RECURRING CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
5311/23/2020CHECKCARD 1121 HOME INSPECTOR PR 8887504777 CA 75187420326000000991251 CKCD 1799 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
5411/23/2020CHECKCARD 1123 WAL SAM'S Club RICHMOND TX CKCD 5300 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
5511/24/2020CHECKCARD 1123 FREEDOM VOICE SYS 800-4771477 CA 75418230328107745097286 RECURRING CKCD 4814 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
5611/24/2020CHECKCARD 1123 INTER NACHI BOULDER CO 25247800328002937044380 RECURRING CKCD 8699 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
5711/27/2020CHECKCARD 1126 Audible*9S2802SU3 Amzn.com/billNJ 55432860331200319072323 CKCD 5968 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
5811/30/2020CHECKCARD 1128 ISG/SF 0000024778 5122179880 TX 55429500333637402240140 CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
5911/30/2020CHECKCARD 1128 SAMS CLUB #476 KATY TX CKCD 5542 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
6011/30/2020CHECKCARD 1128 ISG/SF 0000024784 5122179880 TX 55429500333637432104886 CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
6111/2/2020Monthly Fee for Business Advantage
6211/18/2020CHECKCARD 1118 Freelancer.com London 15265670323008236415858 RECURRING CKCD 7399 XXXXXXXXXXXX5599 INTERNATIONAL TRANSACTION FEE
6311/18/2020CHECKCARD 1118 Freelancer.com London 15265670323008217068726 RECURRING CKCD 7399 XXXXXXXXXXXX5599 INTERNATIONAL TRANSACTION FEE
Sheet1
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

alidurfani Yes it is possible to find partial text in your data. I do on my bank statement using a small program. If you want to know more you would have to use this XL2BB again showing us what your input data looks like and showing us what you want your output data to look like. Now I am going to assume the above data is your input data. If that is the case then you just need to show us what you want for your output data.​

 
Upvote 0
is that what you want?
DateDescriptionManual DescriptionNumberAccount
11/02/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
11/03/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
11/04/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
11/09/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
11/12/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
16/11/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
17/11/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
18/11/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
19/11/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
27/11/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
30/11/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
11/02/2020Monthly Fee for Business Advantagebank service fee73100Bank Charges & Fees:Service Charges
13/11/2020HCTRA EFT DES:EZTAGSTCCD ID:XXXXXXXXX INDN:HABIB OTHMAN CO ID:2746019451 CCDTolls69100Travel:Tolls and Parking
16/11/2020WELLS FARGO AUTO DES:DRAFT ID:510660015508 INDN:HABIB,,OTHMAN CO ID:0122287170 PPDTruck27100Notes Payable:Loan-2017 Honda Ridgeline Financing
16/11/2020WELLS FARGO AUTO DES:DRAFT ID:510660015508 INDN:HABIB,,OTHMAN CO ID:0122287170 PPDInterest77100Interest Paid:Vehicle Financing
16/11/2020BARCLAYCARD US DES:CREDITCARD ID:XXXXXXXXX INDN:HABIB OTHMAN CO ID:2510407970 WEBcomputer22300Other Current Liabilities:Loan-Computer Finance
17/11/2020IPFS866-412-1793 DES:IPFSPMTAZP ID:413868 INDN:BULLS EYE HOME INSPECT CO ID:0131659615 CCDE&O insurance67300Insurance:Liability and E&O insurance
25/11/2020AscentiumCapital DES:LEASECHG ID:141994 INDN:BULLSEYE HOME INSPECTI CO ID:9176794002 CCDEquipment lease for another business66100Equipment Lease
25/11/2020AMZ_STORECRD_PMT DES:PAYMENT ID:604578112099349 INDN: 6045781120993497 CO ID:9069872000 PPDequipment70100Education and Training Expenses:Equipment Training
 
Upvote 0
I don't know what the partial text is. How do we know what partial text to look up?
 
Upvote 0

alidurfani Yes it is possible to find partial text in your data. I do on my bank statement using a small program. If you want to know more you would have to use this XL2BB again showing us what your input data looks like and showing us what you want your output data to look like. Now I am going to assume the above data is your input data. If that is the case then you just need to show us what you want for your output data.​

Do I need to send again the same data which I sent in #1?
 
Upvote 0
is that what you want?
DateDescriptionManual DescriptionNumberAccount
11/02/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
11/03/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
11/04/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
11/09/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
11/12/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
16/11/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
17/11/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
18/11/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
19/11/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
27/11/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
30/11/2020MERCHANT BANKCD DES:DEPOSIT ID:496297789885 INDN:BULLSEYE HOME INSPECTI CO ID:GXXXXXXXXX CCDIncome41000Income - Services:General Home Inspection
11/02/2020Monthly Fee for Business Advantagebank service fee73100Bank Charges & Fees:Service Charges
13/11/2020HCTRA EFT DES:EZTAGSTCCD ID:XXXXXXXXX INDN:HABIB OTHMAN CO ID:2746019451 CCDTolls69100Travel:Tolls and Parking
16/11/2020WELLS FARGO AUTO DES:DRAFT ID:510660015508 INDN:HABIB,,OTHMAN CO ID:0122287170 PPDTruck27100Notes Payable:Loan-2017 Honda Ridgeline Financing
16/11/2020WELLS FARGO AUTO DES:DRAFT ID:510660015508 INDN:HABIB,,OTHMAN CO ID:0122287170 PPDInterest77100Interest Paid:Vehicle Financing
16/11/2020BARCLAYCARD US DES:CREDITCARD ID:XXXXXXXXX INDN:HABIB OTHMAN CO ID:2510407970 WEBcomputer22300Other Current Liabilities:Loan-Computer Finance
17/11/2020IPFS866-412-1793 DES:IPFSPMTAZP ID:413868 INDN:BULLS EYE HOME INSPECT CO ID:0131659615 CCDE&O insurance67300Insurance:Liability and E&O insurance
25/11/2020AscentiumCapital DES:LEASECHG ID:141994 INDN:BULLSEYE HOME INSPECTI CO ID:9176794002 CCDEquipment lease for another business66100Equipment Lease
25/11/2020AMZ_STORECRD_PMT DES:PAYMENT ID:604578112099349 INDN: 6045781120993497 CO ID:9069872000 PPDequipment70100Education and Training Expenses:Equipment Training
Yes that is what I want.
 
Upvote 0
I don't know what the partial text is. How do we know what partial text to look up?
If you see in column B in both of file there is part of some text matches with each other.
 
Upvote 0
remove step: Distinct then refresh green table
Power Query:
// Merge1
let
    Source = Table.NestedJoin(November,{"Description"},October,{"Description"},"October",JoinKind.Inner),
    Expand = Table.ExpandTableColumn(Source, "October", {"Manual Description", "Number", "Account"}, {"Manual Description", "Number", "Account"})
in
    Expand
 
Upvote 0

Similar threads

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top