Search results: xmatch function

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

even seasoned excel users often find themselves stuck performing tasks manually that could be automated with a few clever functions.