Video • 5 minutes
Learning Objectives
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!