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.
Tag Archives | LOOKUP
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.
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.
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.
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.
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.