Find or check if a cell contains text from a list of values in Google Sheets (3 methods) - Tutorial
Автор: KeyCuts
Загружено: 2024-12-02
Просмотров: 3961
You have a list of sentences or values in one column. Another column contains a word or phrase. You want to check if the first column contains the text in the 2nd column. Additionally, you may want to return a different value from the list of words (another column). This tutorial walks through 3 methods for checking if a cell contains text from another list of values. It's also like doing a partial match from a list of values with another list of values.
Setting up the problem - 0:00
Method #1: Using SEARCH to see if cell contains value from list - 2:09
Method #2: COUNTIF and XLOOKUP to return column from list - 14:24
Method #3: SEARCH and XLOOKUP to return column from list - 18:46
👉 Intro to Excel class: https://skl.sh/3Ctmjq9
👉 Subscribe to Dear Analyst: https://podcasts.apple.com/us/podcast...
👉 TikTok: / dear.analyst
👉 Instagram: / dear.analyst
👉 Original blog post for this podcast episode: https://www.thekeycuts.com/dear-analy...
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: