Learn about XMATCH: Excel function is much smarter than VLOOKUP
vlookup used to frustrate people with its rigid limitations and cumbersome syntax. but not anymore. there's an excel function that can handle lookups in all directions and provides
Tags : xmatch function
8 little-known Excel functions that can save you a lot of work
even seasoned excel users often find themselves stuck performing tasks manually that could be automated with a few clever functions.