LOOKUP function


Excel » Functions » Lookup and reference » LOOKUP function »

Distribute values across numerical ranges

This article demonstrates how to distribute values into specific ranges with possible overlapping ranges. I have written articles about filter […]

Find last value in a column

This article demonstrates formulas that return the last value in a given cell range or column. The image above shows […]

Lookup and match last value – reverse lookup

This article shows a formula that performs a reverse lookup and returns the corresponding value based on the last matching […]

How to use the LOOKUP function

Finds a value in a sorted cell range and returns a value on the same row.

Find last matching value in an unsorted list

This article demonstrates a formula that returns the last matching value based on a given condition. The above image shows […]

How to return a value if lookup value is in a range

In this article, I will demonstrate four different formulas that allow you to lookup a value that is to be found […]

5 easy ways to extract Unique Distinct Values

First, let me explain the difference between unique values and unique distinct values, it is important you know the difference […]