# Nearest value ### 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.

### 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.

### Round a number to nearest multiple in EXCEL

to Round to the nearest 0,01, 0,1, 1, 10, 100 is not difficult – for this there is a function round(). But if you want to round, for example, to the nearest multiple of 50?