It’s an often-overlooked fact that XLOOKUP needn’t work with just a single lookup value or even a single search column. The search value is straight forward, you’d expect that a single value could be a string pieced together from multiple sources. Before going further let’s look at an example, this first sheet of data represents […]