Excel Tips: Calculation & Formulas > Look for a Value

Find Closest Value

How to find closest or nearest value in Excel?

How to find closest value greater than or less than in Excel?

How to find the closest date to today on a list in Excel?

How to highlight the closest value in a list to a given number in Excel?

Find Value by Position

How to find the first / last positive / negative number in Excel?

How to find the first / last value greater than X in Excel?

How to find the first numeric cell in an Excel range?

Find Most Common Value

How to find common values in 3 columns in Excel?

How to find most common number or text in a list in Excel?

How to find most common value (number or text string) from a list in Excel?

How to find the least or most common / frequent value in Excel?

How to find the mode for text value from a list/column in Excel?

How to find the most common text value in a list in Google sheets?

How to find the second most common/frequent number or text in Excel?

How to find value with highest frequency in a range in Excel?

Others

How to display specific text based on values in another column?

How to look up a value and return the cell above or below in Excel?

How to lookup a value and return cell address in Excel?

How to lookup first non-zero value and return corresponding column header in Excel?

How to populate rows based on specified cell value in Excel?

How to return another cell if one cell equals text or another in Excel?

How to return cell value every five or nth row in Excel?

How to return the first / last non blank cell in a row or column?