IF with Partial Match in Excel

IF with Partial Match in Excel

Video • 5 minutes

Learning Objectives

  1. Identify and categorise data with partial matches with IF, SEARCH, and ISNUMBER functions.

    Lesson Description

    In this lesson, we tackle the challenge of identifying data in a list using the IF function with a partial match. Imagine you're a fruit supplier armed with a spreadsheet containing customer names and their favourite fruits based on purchase data. Your task? To identify if the fruit listed in column B is a berry and label it accordingly in column D. We’ll attempt an initial IF statement with a wildcard to find berries. Surprisingly, it won’t work due to wildcard limitations in IF. So, join us in this lesson as we navigate the nuances of partial matching in Excel – with fruitful results!