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.
Leave a Comment