LOOKUP function

Excel » Functions » Lookup and reference » LOOKUP function »

Filter values based on numerical ranges

Eero S asks: Thank you *so* much for your detailed examples and actively replying to users! I have a problem, […]

Find last value in a column

The formula in cell D3 lets you get the last value in column B, it works fine with blank cells […]

Find last matching value in an unsorted table

DonW asks: Ok, you've shown it for regular ranges....how about within tables. I have a table similar to: ID Name […]

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

I read an interesting blog post Find Last Item in Group With Index Match written by Debra Dalgleish. It is about […]

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

In this article, I will demonstrate ways to lookup values that is to be found between given ranges and return […]

5 easy ways to extract unique distinct values

You have quite a few options to choose from if you are looking for a way to create a unique […]