How to check if a cell value match to a list in Excel?

You have come to the correct spot if you are seeking for some of the simplest ways to verify if a value is present in a list in Excel, and you will find those options in this tutorial. You can use the procedures outlined in this tutorial to easily check out your target value across a vast range of data by following them.

You can check a value in the vegetable list below by using the "Find & Replace" function. Just click on the value. The product okra is what we are looking for at this time.

Let’s understand step by step with an example.

Step 1

In the first step, we must create some sample data. Refer to the below screenshot for same.

Step 2

After making sure that the entire column of the vegetables list is selected, press the Ctrl+F keys at the same time to bring up the Find and Replace dialog box. Next, on the Find tab, enter the name or value that you want to find and check into the Find what textbox, and then click Find All to list the results of your search. Check out this below screenshot.

Note − You may use this option to open find and Replace function. Select the Home Tab, Editing Groups, Find & Select Dropdown, and then the Find option. Now, it will show the Find and Replace Dialog Box.

Step 3

In the case of a successful match, the corresponding values will be displayed in the table below. Refer to the below screenshot.

Step 4

However, if there is not a value that matches, a reminder will appear in the form of a dialog box. Check out the screenshots below.

If the string that you are finding is not present in the given list, then Excel will display the following dialog box.

Step 6

Then, click the OK button. Now, you can see in the Find and Replace dialog box a message appeared as 0 cells found. Refer to the below screenshot.

Conclusion

In this tutorial, we used a simple example to show how you can check if a value match to a list with the Find and Replace function in Excel.