It’s shunned upon in the Excel pro scene (shout-out to my boi Makro), but xlookup can be used instead