Look it up with Excel Hlookup Function : Sample workbooks for downloads are located below.
Free Microsoft Office Tutorials
Excel Hlookup Function tutorial with downloads and video support
The Excel Hlookup Function is similar to the Vlookup function. Instead of referencing columns it references rows.
Watch this short video tutorial
The Excel Hlookup Function is an old function that has been brought over from Lotus 1-2-3. You may find this function helpful. I have 2 workbooks here that you can download with a practical demonstration of how you can use the Hlook up function to fill-in addresses from a list. Why not download these two workbooks and have a more in-depth look at the Excel Hlookup Function.
Please subscribe to Online PC Learning before downloading
The second workbook shows the use of both Hlookup and the Vlookup combined to look up staff details.
[wpdm_file id=36 title="true" template="bluebox "]
Vlookup is used with the Hlookup function in this demonstration.
I would strongly recommend that you watch our tutorial dealing with the Index Match functions as well as this tutorial and decide which you prefer to use. The Index and Match functions will do this all without the index numbers.