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 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 […]