# How to Add Tags in Excel: 2 Simple Ways

### Method 1 – Use of Functions to Tags

See how to add tags to Excel using a formula combining different Excel functions. Get to know the dataset we are going to use for the article. We prepared a dataset consisting of Movie names and their Genres.

You will have a Result and Tag column.

The Result column will output after inserting any Genre name in the Tag cell.

• Insert any Genre name. We chose Drama.

• Write the following formula in D5 and press ENTER.
`=IF(ISNUMBER(SEARCH(\$E\$5,C5)),\$E\$5,"Not "&\$E\$5)`

The SEARCH function searches the tag name within the desired cell and finds that the function returns a number. ISNUMBER checks whether there is a number or not, and the IF function performs the rest of the task of adding the appropriate result.

See that the first movie is Not Drama.

• Hold and Drag the D5 cell downward.

Get results for all other movies.

Change the tag name. We got a column of results indicating which movie is a thriller and which is not.

### Method 2 – Use of Excel Filter to Add Tags

• Select the data table.

• Go to the Editing bar and select the Filter option from the Sort & Filter tab.

You will see some bars on both columns.

• Select the Genre bar.

A window similar to this will open.

• Write a specific Genre in the Text Filters box and press OK.

The Filter feature will show us records with the Genre name.

Download Practice Workbook

You can download and practice from this workbook.

## Related Articles

<< Go Back to Tags in ExcelData Analysis with Excel Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sourav Kundu

Sourav Kundu, BSc, Naval Architecture & Marine Engineering, Bangladesh University of Engineering and Technology, is a dedicated technical content creator of the ExcelDemy project. He has a keen interest in Excel and he leverages his problem-solving skills to provide solutions on user interface with Excel. In his position as an Excel & VBA Content Developer at ExcelDemy, Sourav Kundu not only adeptly addresses challenging issues but also demonstrates enthusiasm and expertise in navigating complex situations. Apart from creating... Read Full Bio

2 Comments
1. how to search with two tags?

• Hello Tigran,

You can use a combined formula to search with two tags in Excel. Use the SEARCH function for each tag and the AND or OR operators to meet your criteria.

Formula:

=AND(ISNUMBER(SEARCH(“Tag1”, A2)), ISNUMBER(SEARCH(“Tag2”, A2)))

This formula will return TRUE if both tags are found in the text, or FALSE otherwise. Based on your criteria and need you can adjust this formula tags and reference.

Regards
ExcelDemy

Advanced Excel Exercises with Solutions PDF