Lookup Partial Text

Status
Not open for further replies.

alidurfani

Board Regular
Joined
Apr 12, 2019
Messages
164
Office Version
  1. 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/2020CHECKCARD 1004 JAF CPA SPRING TX 85500390278900015600858 CKCD 8931 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Accountant68100Legal & Professional Services:Accounting & Bookkeeping Services
610/5/2020CHECKCARD 1003 AMZN MKTP US*MK9P AMZN.COM/BILLWA 55310200277083361873513 CKCD 5942 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Tools51000Cost of Goods Sold:Tools
710/5/2020CHECKCARD 1003 AMZN MKTP US*MK29 AMZN.COM/BILLWA 55310200277083722396733 CKCD 5942 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Tools51000Cost of Goods Sold:Tools
810/6/2020CHECKCARD 1005 ISG/SF 0000023164 5122179880 TX 55429500280637569305036 CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Termite inspection fee56000Cost of Goods Sold:Termite Inspection COS
910/7/2020CHECKCARD 1006 PLUM DIGITAL MARK 8009929663 MA 55429500280637584725671 RECURRING CKCD 5818 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Digital marketing63300Advertising & Marketing:Other Marketing
1010/7/2020CHECKCARD 1006 ISG/SF 0000023175 5122179880 TX 55429500280637620713400 CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Termite inspection fee56000Cost of Goods Sold:Termite Inspection COS
1110/8/2020CHECKCARD 1007 ACTBLUE*JOE.BIDEN ACTBLUECC.COMMA 75418230281104422321860 CKCD 8651 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Charitable Contributions74000Charitable Contributions
1210/8/2020CHECKCARD 1006 GOIN' POSTAL RICHMOND TX 85428140281980027637968 CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Postage & Shipping72100Office Supplies and Expenses:Postage & Shipping
1310/8/2020CHECKCARD 1007 BLIPP REVIEWS - U 8019950318 UT 55429500282637748332735 RECURRING CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Online review expenses63300Advertising & Marketing:Other Marketing
1410/9/2020CHECKCARD 1009 Freelancer.com London 15265670283000473234942 RECURRING CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Design Expenses63700Advertising & Marketing:Design Expenses
1510/9/2020CHECKCARD 1009 Freelancer.com London 15265670283000480925854 RECURRING CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Design Expenses63700Advertising & Marketing:Design Expenses
1610/9/2020CHECKCARD 1009 Freelancer.com London 15265670283000473234942 RECURRING CKCD 7399 XXXXXXXXXXXX5599 INTERNATIONAL TRANSACTION FEEDesign Expenses63700Advertising & Marketing:Design Expenses
1710/9/2020CHECKCARD 1009 Freelancer.com London 15265670283000480925854 RECURRING CKCD 7399 XXXXXXXXXXXX5599 INTERNATIONAL TRANSACTION FEEDesign Expenses63700Advertising & Marketing:Design Expenses
1810/9/2020Zelle Transfer Conf# XXXXXXXXX; BRC HOME SERVICE LLCIncome41000Income - Services:General Home Inspection
1910/13/2020Online Banking transfer to CHK 3960 Confirmation# 3329869163Drawing32300Owner's Equity:Owner Drawings
2010/13/2020CHECKCARD 1010 FIVERR * 9543682267 NY 55429500284894009413179 CKCD 7299 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Advertising63900New Website SEO
2110/13/2020CHECKCARD 1012 LaunchGood Inc. 8559991947 MI 15270210286427198357440 RECURRING CKCD 8398 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Charitable Contributions74000Charitable Contributions
2210/13/2020CHECKCARD 1010 FIVERR * 9543682267 NY 55429500284894007866915 CKCD 7299 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Advertising63900New Website SEO
2310/13/2020CHECKCARD 1013 Freelancer.com London 15265670286428775574946 RECURRING CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Design Expenses63700Advertising & Marketing:Design Expenses
2410/13/2020CHECKCARD 1013 CRAIGSLIST.ORG 415-399-5200 CA 55432860287200807321848 CKCD 5969 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Advertising63300Advertising & Marketing:Other Marketing
2510/13/2020CHECKCARD 1013 Freelancer.com London 15265670286431298468729 RECURRING CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Design Expenses63700Advertising & Marketing:Design Expenses
2610/13/2020CHECKCARD 1013 Freelancer.com London 15265670286428775574946 RECURRING CKCD 7399 XXXXXXXXXXXX5599 INTERNATIONAL TRANSACTION FEEDesign Expenses63700Advertising & Marketing:Design Expenses
2710/13/2020CHECKCARD 1013 Freelancer.com London 15265670286431298468729 RECURRING CKCD 7399 XXXXXXXXXXXX5599 INTERNATIONAL TRANSACTION FEEDesign Expenses63700Advertising & Marketing:Design Expenses
2810/14/2020BARCLAYCARD US DES:CREDITCARD ID:XXXXXXXXX INDN:HABIB OTHMAN CO ID:2510407970 WEBcomputer22300Other Current Liabilities:Loan-Computer Finance
2910/14/2020CHECKCARD 1013 ISG/SF 0000023423 5122179880 TX 55429500287637235846309 CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Termite inspection fee56000Cost of Goods Sold:Termite Inspection COS
3010/16/2020WELLS FARGO AUTO DES:DRAFT ID:510660015508 INDN:HABIB,,OTHMAN CO ID:0122287170 PPDTruck27100Notes Payable:Loan-2017 Honda Ridgeline Financing
3110/16/2020CHECKCARD 1015 ISN/CI 8007008112 NV 55506290289726680580455 CKCD 7372 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599ISN65600Communication and Technology:Software Expense
3210/16/2020WELLS FARGO AUTO DES:DRAFT ID:510660015508 INDN:HABIB,,OTHMAN CO ID:0122287170 PPDInterest77100Interest Paid:Vehicle Financing
3310/16/2020CHECKCARD 1016 SAMS CLUB #470 FRIENDSWOOD TX CKCD 5542 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599gas62200Vehicle Expenses:Fuel and Gasoline
3410/20/2020Online Banking transfer to CHK 3960 Confirmation# 2221847077Drawing32300Owner's Equity:Owner Drawings
3510/20/2020HCTRA EFT DES:EZTAGSTCCD ID:XXXXXXXXX INDN:HABIB OTHMAN CO ID:2746019451 CCDTolls69100Travel:Tolls and Parking
3610/21/2020CHECKCARD 1021 HOME INSPECTOR PR 8887504777 CA 75187420295000000914474 CKCD 1799 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599software icloud monthly fee65600Communication and Technology:Software Expense
3710/21/2020BKOFAMERICA MOBILE 10/21 3823045254 DEPOSIT *MOBILE TXIncome41000Income - Services:General Home Inspection
3810/22/2020PAYPAL DES:INST XFER ID:ASTRINGER INDN:HABIB OTHMAN CO ID:PAYPALSI77 WEBMarketing on Facebook63800Advertising & Marketing:Facebook
3910/22/2020CHECKCARD 1022 SAMSCLUB #6867 RICHMOND TX CKCD 5542 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599gas62200Vehicle Expenses:Fuel and Gasoline
4010/26/2020AMZ_STORECRD_PMT DES:PAYMENT ID:604578112099349 INDN: 6045781120993497 CO ID:9069872000 PPDequipment70100Education and Training Expenses:Equipment Training
4110/26/2020CHECKCARD 1023 INTER NACHI BOULDER CO 25247800297002827050858 RECURRING CKCD 8699 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599membership82300Licenses/Permit/Dues/Subscriptions:Dues & subscriptions
4210/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
4310/27/2020CHECKCARD 1026 ISG/SF 0000023837 5122179880 TX 55429500301637417535359 CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Termite inspection fee56000Cost of Goods Sold:Termite Inspection COS
4410/28/2020CHECKCARD 1028 Freelancer.com London 15265670302000198048723 RECURRING CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Design Expenses63700Advertising & Marketing:Design Expenses
4510/28/2020CHECKCARD 1028 SAMSCLUB #4712 HOUSTON TX CKCD 5542 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599gas62200Vehicle Expenses:Fuel and Gasoline
4610/28/2020CHECKCARD 1027 ISG/SF 0000023854 5122179880 TX 55429500301637471968181 CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Termite inspection fee56000Cost of Goods Sold:Termite Inspection COS
4710/28/2020CHECKCARD 1026 BURGER KING #4396 KATY TX 55431800301400331000889 CKCD 5814 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Meals71500Meals & Entertainment:Business Related Meals
4810/28/2020CHECKCARD 1028 Freelancer.com London 15265670302000199744940 RECURRING CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Design Expenses63700Advertising & Marketing:Design Expenses
4910/28/2020CHECKCARD 1028 Freelancer.com London 15265670302000198048723 RECURRING CKCD 7399 XXXXXXXXXXXX5599 INTERNATIONAL TRANSACTION FEEDesign Expenses63700Advertising & Marketing:Design Expenses
5010/28/2020CHECKCARD 1028 Freelancer.com London 15265670302000199744940 RECURRING CKCD 7399 XXXXXXXXXXXX5599 INTERNATIONAL TRANSACTION FEEDesign Expenses63700Advertising & Marketing:Design Expenses
5110/29/2020CHECKCARD 1028 CHEVRON 0305116 HOUSTON TX 55432860302200822590469 CKCD 5542 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599Fuel62200Vehicle Expenses:Fuel and Gasoline
Sheet1


November file

November.xlsx
ABCDEFGH
2DateDescriptionAmountDepositWithdrawalManual DescriptionNumberAccount
311/2/2020Online Banking transfer to CHK 3960 Confirmation# 2218107275-3500.00-3500.00
411/10/2020Online Banking transfer to CHK 3960 Confirmation# 3201130075-2000.00-2000.00
511/13/2020HCTRA EFT DES:EZTAGSTCCD ID:XXXXXXXXX INDN:HABIB OTHMAN CO ID:2746019451 CCD-100.00-100.00
611/16/2020WELLS FARGO AUTO DES:DRAFT ID:510660015508 INDN:HABIB,,OTHMAN CO ID:0122287170 PPD-599.75-575.22
711/16/2020WELLS FARGO AUTO DES:DRAFT ID:510660015508 INDN:HABIB,,OTHMAN CO ID:0122287170 PPD-24.53
811/16/2020BARCLAYCARD US DES:CREDITCARD ID:XXXXXXXXX INDN:HABIB OTHMAN CO ID:2510407970 WEB-145.00-145.00
911/17/2020Online Banking transfer to CHK 3960 Confirmation# 1561834780-1000.00-1000.00
1011/25/2020Online Banking transfer to CHK 7923 Confirmation# 1229015051-1000.00-1000.00
1111/25/2020Online Banking transfer to CHK 3960 Confirmation# 2229026532-1000.00-1000.00
1211/25/2020AMZ_STORECRD_PMT DES:PAYMENT ID:604578112099349 INDN: 6045781120993497 CO ID:9069872000 PPD-200.00-200.00
1311/30/2020Online Banking transfer to CHK 3960 Confirmation# 1270874052-2500.00-2500.00
1411/4/2020CHECKCARD 1103 IN *J3 RESOURCES, 713-2900221 TX 55432860308200406920029 CKCD 7392 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-90.00-90.00
1511/5/2020CHECKCARD 1104 TX BD ENG LIC REN 5124403063 TX 55488720310091332000464 CKCD 9399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-40.00-40.00
1611/5/2020CHECKCARD 1105 eBay O*02-06012-0 San Jose CA 15270210310001147494941 CKCD 5311 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-138.11-138.11
1711/6/2020CHECKCARD 1105 GILLMAN HONDA HOUSTON TX 55310200310207098200075 CKCD 5511 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-54.95-54.95
1811/6/2020CHECKCARD 1105 AMZN MKTP US*289V AMZN.COM/BILLWA 55310200311083703189089 CKCD 5942 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-16.99-16.99
1911/6/2020CHECKCARD 1106 SAMSCLUB #4712 HOUSTON TX CKCD 5542 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-25.29-25.29
2011/9/2020CHECKCARD 1106 AMZN MKTP US*287L AMZN.COM/BILLWA 55310200311083360221092 CKCD 5942 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-8.34-8.34
2111/9/2020CHECKCARD 1107 TST* RUDY S COUNT SPRING TX 02305370312500225745329 CKCD 5812 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-14.80-14.80
2211/9/2020CHECKCARD 1107 BLIPP REVIEWS - U 8019950318 UT 55429500313637524641450 RECURRING CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-1.50-1.50
2311/12/2020CHECKCARD 1110 PHO KIM LONG KATY TX 75217690316450000783436 CKCD 5812 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-11.20-11.20
2411/12/2020CHECKCARD 1110 JAF CPA SPRING TX 85500390315900015700869 CKCD 8931 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-220.00-220.00
2511/12/2020WAL SAM'S Club 11/11 #000100638 PURCHASE 6867 WAL-SAMS RICHMOND TX-68.25-68.25
2611/13/2020CHECKCARD 1112 ISN/CI 8007008112 NV 55506290317726497439966 CKCD 7372 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-20.00-20.00
2711/13/2020CHECKCARD 1113 SAMS CLUB #686 RICHMOND TX CKCD 5542 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-27.54-27.54
2811/16/2020CHECKCARD 1113 IN *J3 RESOURCES, 713-2900221 TX 55432860318200017052442 CKCD 7392 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-100.00-100.00
2911/18/2020CHECKCARD 1118 Freelancer.com London 15265670323008236415858 RECURRING CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-41.22-41.22
3011/18/2020CHECKCARD 1118 Freelancer.com London 15265670323008217068726 RECURRING CKCD 7399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-1.53-1.53
3111/23/2020CHECKCARD 1121 HOME INSPECTOR PR 8887504777 CA 75187420326000000991251 CKCD 1799 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-20.00-20.00
3211/23/2020CHECKCARD 1123 WAL SAM'S Club RICHMOND TX CKCD 5300 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-3.26-3.26
3311/24/2020CHECKCARD 1123 FREEDOM VOICE SYS 800-4771477 CA 75418230328107745097286 RECURRING CKCD 4814 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-11.09-11.09
3411/24/2020CHECKCARD 1123 INTER NACHI BOULDER CO 25247800328002937044380 RECURRING CKCD 8699 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-49.00-49.00
3511/27/2020CHECKCARD 1126 Audible*9S2802SU3 Amzn.com/billNJ 55432860331200319072323 CKCD 5968 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-15.88-15.88
3611/30/2020CHECKCARD 1128 ISG/SF 0000024778 5122179880 TX 55429500333637402240140 CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-20.00-20.00
3711/30/2020CHECKCARD 1128 SAMS CLUB #476 KATY TX CKCD 5542 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-27.43-27.43
3811/30/2020CHECKCARD 1128 ISG/SF 0000024784 5122179880 TX 55429500333637432104886 CKCD 5734 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599-20.00-20.00
3911/2/2020Monthly Fee for Business Advantage-29.95-29.95
4011/18/2020CHECKCARD 1118 Freelancer.com London 15265670323008236415858 RECURRING CKCD 7399 XXXXXXXXXXXX5599 INTERNATIONAL TRANSACTION FEE-1.24-1.24
4111/18/2020CHECKCARD 1118 Freelancer.com London 15265670323008217068726 RECURRING CKCD 7399 XXXXXXXXXXXX5599 INTERNATIONAL TRANSACTION FEE-0.05-0.05
Sheet1
Cell Formulas
RangeFormula
E8:E41,E3:E5E3=C3
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
52,833
Office Version
  1. 365
Platform
  1. Windows
Duplicate Partial Text Lookup

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,122,354
Messages
5,595,672
Members
414,008
Latest member
zcaa0g

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
Top