Text › SEARCH, ISNUMBER55 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

MediumFreeSEARCHISNUMBER

SEARCH & ISNUMBER: find the spicy dishes

Rahma runs a restaurant in Padang and is preparing an online menu. Any dish whose name contains the word "pedas" (Indonesian for spicy), whether at the start, in the middle, or in capitals, will get a chili icon.

Task

Fill B2:B8 with TRUE if the dish name in column A contains the word "pedas" (in any letter case), otherwise FALSE. Use SEARCH and ISNUMBER.

Cells to fillB2:B8

Required functionsSEARCHISNUMBER

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
SEARCH(find, text) returns the position of the word if it is found, and a #VALUE! error if it is not. SEARCH ignores letter case.
Hint 2
ISNUMBER turns that result into TRUE (found, so it is a number) or FALSE (an error).
Hint 3
Wrap SEARCH("pedas", A2) in ISNUMBER.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

B2:B8

=ISNUMBER(SEARCH("pedas",A2))

Write it in B2, then fill down to B8.

Explanation

The ISNUMBER(SEARCH(…)) pattern is the classic way to ask "does this text contain a certain word?". SEARCH finds both "PEDAS" and "pedas", while FIND is case-sensitive, so "Mie PEDAS Level 5" would be missed. Watch out for very short search words: searching for "es" also matches "Pedas". Tip: this TRUE/FALSE result can be used directly as a condition in IF or FILTER.

Starting worksheet: Sheet1
Row	A	B
1	Menu	Spicy?
2	Ayam Bakar Pedas Manis
3	Nasi Goreng Kampung
4	Mie PEDAS Level 5
5	Sate Padang
6	Keripik pedas balado
7	Es Teh Manis
8	Sayap Ayam Super Pedas
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result