Excel IF Function with PARTIAL Text Match (IF with Wildcards)

Leila Gharani • May 30, 2019

Leila Gharani

About

Excel. Power Query. Copilot. ChatGPT. Power BI. PowerPoint. You use them every day to automate Excel and your work - so why not actually master them? I’ll show you how to: ✔️Automate the stuff that drives you nuts ✔️ Spend less time on grunt work, more time on wow work ✔️ Build reports that look good AND actually make sense What You’ll Learn Here: ✔️ Excel, Power BI, PowerPoint, VBA, Google Sheets & more ✔️ AI-powered Excel & the future of work ✔️ Data & finance skills that give you an edge I don’t just teach this stuff - I use it daily. My goal? To help you think differently about the tools you already have, so you can work faster, and with confidence. 🎓 My background: MA in economics / Economist / Business Consultant / Accounting Systems Expert / Oracle & SAP implementations (for Finance) / Teacher & Microsoft MVP 💡 400,000+ professionals have taken my courses at XelPlus - because working smarter just makes sense. Join here 👉 https://www.xelplus.com/courses/

Excel IF Function with PARTIAL Text Match (IF with Wildcards)

Leila Gharani

About

Latest Posts

Power BI Card Visuals - Full Tutorial (Dec 2025)

Learn to Automate Everything with Power Query in Excel (Download Files)

Python in Excel: 1-minute Hacks You Can Use Today

How to Use VLOOKUP in Excel (free file included)

You May Also Like

Upgrade Your Smartphone

VANMASS [85+LBS Strongest Suction &amp; Clip] 2025 Upgrade Car Phone Holder [Patent &amp; Safety Certs] Cell Phone Mount Truck Stand for Dashboard Windshield Vent for iPhone 16 Pro Max 15 14 13 12 Samsung

iPhone Charger Fast Charging [Apple MFi Certified] USB C to Lightning Cable 6FT USBC to Lightning Cable Nylon Braided Type C Cord for iPhone 14 13 12 11 Pro Max XR XS X 8 7 6 Plus SE, iPad

iPhone Charger [Apple MFi Certified] 3FT, 3Pack USB A to Lightning Cable Braided Fast Charging Apple Cord Compatible with iPhone 14 13 12 11 Pro Max XS XR X 8 7 6 5 Plus iPad/iPod/AirPods

2Pack 10ft iPhone Charger 90 Degree Lightning Cable Right Angle Long USB Charging Cord Compatible with Apple iPhone 14 13 12 11 Pro Max XS XR X 8 7 6 5 Plus iPad iPod

Wireless Charger for Samsung - NANAMI 3 in 1 Charging Station for Multiple Devices,Fast Charger Stand Dock for Galaxy S25 S24 S23 Ultra S22 S21 S20 Z Flip Fold,Galaxy Watch 5/5 Pro/4/3,Galaxy Buds Pro

45W Super Fast Charger USBC Charger, 2Pack 10FT Samsung Charger Fast Charging Cord Cable&amp; Samsung Type C Charger Block for Galaxy S25 S24 S23 S22 S21 Ultra/Plus, Tab S10 S9 S8 S7,iPad,Android Phone

Telaso for iPhone 16 Pro Max Case, iPhone 16 Pro Max Phone Case Compatible with Magsafe Translucent Matte Back Slim Fit Full Body Shockproof Cover for iPhone 16 Pro Max 6.9&quot;, Black

TORRAS Magnetic Slim-Fit for iPhone 16 Pro Max Case, Ultra-Thin 16 ProMax Phone Case Compatible with MagSafe, Light Anti-Scratch Matte Hard PC Bayer 6.9 inch OriginFit, Black

Telaso for iPhone 16 Pro Case, iPhone 16 Pro Phone Case Compatible with Magsafe Translucent Matte Back Slim Fit Full Body Shockproof Anti-Yellow Cover for iPhone 16 Pro 6.3&quot;,Yellow

RALEAVO for iPhone 16 Case Compatible with MagSafe Strong Magnetic Phone Case Clear Floral Case for Women Girls Slim Hard Back Protective Case for iPhone 16 6.1&quot;(Clear/Lavender)

3-Pack, XunyLyee Screen Protector for iPhone 13/13 Pro/iPhone 14/ iPhone 16e 2025 6.1 Inch Tempered Glass Film Bubble Free

JETech Screen Protector for iPhone 16e 2025, iPhone 13/13 Pro 6.1-Inch, Tempered Glass Film, 3-Pack

BASESAILOR iPhone 16 16e Car Charger Adapter 3Pack,USB to USBC Connector Type C Female to A Male Cable Converter for iPhone 15 14 Pro Max Plus,Apple Watch 10,Airpods 4,iPad mini 7,Samsung Galaxy S25

Elebase USB to USB C Adapter 4 Pack,USBC Female to A Male Car Charger,Type C Converter for iPhone 16 Pro Max,15 14 13 12 11 Plus,Apple Watch iWatch 10 9 8,Airpods,iPad Air Mini 6 7,Samsung Galaxy S25

2 Pack Magnetic Wireless Charger 15W Fast Mag-Safe Charger Stand Compatible with iPhone 16/15/14/13/12 Series Wireless Charging Pad for AirPods 3/2/Pro 2/Pro White Portable Mag Safe Kickstand

Magnetic Wireless Charger for iPhone: Fodable 3 in 1 Charging Station for Multiple Apple Devices - Travel Charging Pad Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus &amp; Airpod Global Recycled Standard

Wireless Earbuds, 2025 Bluetooth 5.4 Bass Stereo Headphones with 4 ENC Mic, 48H Playback Ear Buds with Charging Case LED Display,Sport Earphones IPX7 Waterproof for Phone, Android, Pad, White

Wireless Charging Case for AirPods Pro 1st / 2nd Gen with Type-C Charging Port, Compatible with AirPod Pro 2nd Generation Replacement Case, with Blue-Tooth Sync Button, No Earbuds

Cleaner Kit for Airpods Pro 1 2 3 Multi-Function Cleaning Pen with Soft Brush Flocking Sponge for Bluetooth Earphones Case Cleaning Tools White

Apple AirPods Pro 2 Wireless Earbuds, Bluetooth Headphones, Active Noise Cancellation, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging

Wireless Charger, 3 in 1 Charging Station, Fast Charging Station Foldable Charging Stand, Wireless Charging Station for Multiple Devices, Compatible with lPhone 17/16/15/14/13 Pro Max Airpods Watch

ESR Camera Lens Protector for iPhone 16/16 Plus, Tough HD Individual Protectors, Scratch Resistant, Ultra-thin Tempered Glass, Armorite Series, 1 Pack, Clear

Ailun 3 Pack Screen Protector for iPhone 14[6.1 inch] + 3 Pack Camera Lens Protector,Case Friendly Tempered Glass Film,[9H Hardness] - HD

Ailun 3 Pack Screen Protector for iPhone 17 [6.3 inch] + 3 Pack Camera Lens Protector with Installation Frame,Sensor Protection,Dynamic Island Compatible,Case Friendly Tempered Glass Film

[2+2] LK 2 Pack Compatible for iPhone 16 Screen Protector + 2 Pack Camera Lens Protector, Tempered Glass Film, Ultra HD, 9H Hardness, Bubble Free, Easy Installation, Case Friendly

Galaxy S24 S25 USB C Charging Block 25W PD Super Fast Charger Type C Wall Plug Adapter Quick Charge for Samsung Galaxy S25/S24/S23/S22/S21/S20/Z Fold 3/4/5/Note20/iPhone 15/16/iPad/Tablet/Watch-1Pack

Loading...

VANMASS [85+LBS Strongest Suction & Clip] 2025 Upgrade Car Phone Holder [Patent & Safety Certs] Cell Phone Mount Truck Stand for Dashboard Windshield Vent for iPhone 16 Pro Max 15 14 13 12 Samsung

45W Super Fast Charger USBC Charger, 2Pack 10FT Samsung Charger Fast Charging Cord Cable& Samsung Type C Charger Block for Galaxy S25 S24 S23 S22 S21 Ultra/Plus, Tab S10 S9 S8 S7,iPad,Android Phone

Telaso for iPhone 16 Pro Max Case, iPhone 16 Pro Max Phone Case Compatible with Magsafe Translucent Matte Back Slim Fit Full Body Shockproof Cover for iPhone 16 Pro Max 6.9", Black

Telaso for iPhone 16 Pro Case, iPhone 16 Pro Phone Case Compatible with Magsafe Translucent Matte Back Slim Fit Full Body Shockproof Anti-Yellow Cover for iPhone 16 Pro 6.3",Yellow

RALEAVO for iPhone 16 Case Compatible with MagSafe Strong Magnetic Phone Case Clear Floral Case for Women Girls Slim Hard Back Protective Case for iPhone 16 6.1"(Clear/Lavender)

Magnetic Wireless Charger for iPhone: Fodable 3 in 1 Charging Station for Multiple Apple Devices - Travel Charging Pad Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus & Airpod Global Recycled Standard