Retrieve the Adjacent Value from a Grid with XLOOKUP & Dynamic Arrays

/in /by

You’ve got a grid and you want to input a code and retrieve the value tied to that code; e.g., input 33 and you want the name Trish.

This is easy if you have a single column of codes alongside a single column of values. That’s a plain VLOOKUP or XLOOKUP. HOWEVER! that’s not how this data is set up.

In this video I show how this can be done. But I also discuss the difference between using a single monstrous formula vs. taking intermediate steps.

We use TOCOL, OFFSET and IFERROR. So easy!

#XLOOKUP #DynamicArrays #OzduSoleil

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guerrilla-data-analysis-3rd-edition/
My old blog: http://datascopic.net/blog-2-2