# Search number values

### Find the nearest date/ number based on criteria in EXCEL. Alternative to VLOOKUP

using the function VLOOKUP() you can search in a table column

### Find the nearest date/ number based on criteria in EXCEL. Unsorted list

Find in the table the greatest date that is less than or equal to a specified (nearest bottom). And of all the dates in the table will take into account only those that relate to a particular product (condition). The list can be primary.

### Separating text and numbers in Excel

If the original list contains both text and numbers, then using array formulas in a single list to select all text values, and the other is numeric.

### Find nth Number Occurrence (Duplicate) in Excel

here are the search numbers in the list with repetitions. Setting as a criterion to search for the desired value and number of repeat in the list, find the row number containing this repeat, and select it and other repetitions of this numbers using Conditional formatting.

### Еxtract rows that meet criteria in Excel (numbers)

Find a numeric value equal to the user-defined criterion. The search will be carried out in the range with duplicate values. In the presence of repetitions, it can be expected that the criterion will correspond to multiple values. Their output is a single range is convenient to use an array formula.

### Find nearest number in EXCEL. Unsorted list

To find the NUMBER closest to the given one, in EXCEL, there are special functions, for example, VLOOKUP(), LOOKUP(), MATCH(), but they only work if the original list is sorted in ascending or descending order. Using array formulas will create a similar formula, but it works in the case of the unsorted list.

### Find nearest number in EXCEL. Sorted list

To find the NUMBER closest to the given one, in EXCEL, there are special functions, for example, VLOOKUP(), but they only work if the original list is sorted in ascending or descending order.

### Classification of Range Search Problems in EXCEL

this article attempts a classification of problems to find the values in MS EXCEL. The article may be interesting for advanced users of EXCEL.