Inside Microsoft Excel

Pinpoint data in an overwhelming data table – no formulas necessary!

Inside Microsoft Excel

by Kara Hiltz

Between scrolling left and right, and then scrolling up and down, searching a huge data table is often inefficient and cumbersome. And of course, there’s always a chance for human error. You could use Excel’s lookup functions to create a formula for seeking out the intersecting cell, but in some cases, you’d need a combination of several of these functions nested within others. Instead, with only a few simple steps, Excel’s Lookup[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)