Microsoft Excel can handle data tables with hundreds or even thousands of rows and columns. That's great, unless you're trying to find a specific cell's value, which could have you scrolling up and down, left and right looking for that needle of data in a haystack of cells. If your table is formatted correctly, you can use Excel's Lookup Wizard to display the data in a cell automatically.
To see if you have the Lookup Wizard installed in Excel 2003, click Tools and look for a Lookup option, probably at the bottom of the menu. In … Read more