503536e6-7df9-ee11-a73d

Gautamsharma13 Apr, 2024Fashion

XLookup is capable of doing look-ups with multiple criteria using two methods, concatenation and another boolean array. Both are pretty straightforward and easy to use. I prefer the boolean array method and have used it a few times. Most examples you find online will show something like this. You have a table of items, with the following columns. Item, Size, Color & Price. The look-up is then done by finding a Price based upon an item that matches a given Item,Size,Color combination as shown in this image. I'm looking for a solution that allows for this. Given the example above, let's say we have striped items, so we have two colors, Color and Color2.