Go Back

How to Limit Your Search to a Column in Excel

Excel allows a user to limit a search of value to a single column. This step by step tutorial will assist all levels of Excel users to learn how to limit a search to a column in Excel.

Figure 1. Searching in a single column

Setting up Our Data for Searching in a Column

Let’s look at the structure of the data we will use. In columns B and E, we have products. In column C, there are amounts and in column D, percentages. In column F, we have total amounts.

Figure 2. Data that we will use in the example

Limit a Search to a Single Column

In our example, we want to search for “Product D” in column B. As we have products in both columns B and E, we must limit our search to column B only.

To enable this, we first need to select a column in which we want to search, in our case, column B. We need to click on column B name, as shown in Figure 3.

Figure 3. Select a column for the search

Now we can press Ctrl+F or go to the Home tab, the icon Find&Select and choose the Find option.

Figure 4. The result of the search

In the Find what text box, we can enter the value which we want to find in column B, which is “Product D”. As a result, the cell B6 is selected, as we can see in Figure 4.

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:

Leave a Comment

avatar