# Tag Archives | LOOKUP

## How To Do A Reverse Lookup Using OFFSET And MATCH In Excel

In this tutorial we are going to look at how we can do a lookup in an array by looking up the values in the far right column and returning the result from a column to the left. We are going to use the OFFSET and MATCH functions to accomplish this.

## How To Use VLOOKUP To Search A Segment Of A Listed Item In Excel

In this tutorial we’ll take a look at how to do a VLOOKUP when you are only searching for a segment of the information in a specific column rather than the entire item.

## How To Do A Lookup In Excel Of Unique Values In A Table That Has Several Of The Same Items

In this tutorial we are going to do a lookup from one table that has multiple quantities for the same items, and ensure that we only pull each unique quantity once into another table sorted in a different order.

## How To Find The Last Match In An Array Using LOOKUP In Excel

In this tutorial we are going to use the LOOKUP function to find the last match in an array and return the corresponding value from another column from that row.

## You Need To Change How You Think When Using Formulas In Conditional Formatting!

I recently received a request to use Conditional Formatting when performing two different comparisons on two data ranges.  How I approached the task was WRONG! Read on to see how I finally got myself on the right track.

## How To Use INDEX and MATCH In A Table With INDIRECT In Excel

In this video we’ll look at the traditional data range lookup using the INDEX and MATCH functions, but add a twist to look up the values in a table, plus a bonus twist using the INDIRECT function.