Excel 2007 HLOOKUP Function
Friday February 20, 2009
After discussing Excel’s VLOOKUP function, I thought I should follow that up with the HLOOKUP function.
Both LOOKUP functions can be used to help you find specific data located in a database or list of data. The difference between the two functions lies in how your data is organized in your spreadsheets.
If the data is organized in columns, you would use VLOOKUP, if the data is kept in rows, you would use HLOOKUP.
For details on how to use the HLOOKUP function in your spreadsheets, including an example, read the article on the Excel 2007 HLOOKUP Function.
Related Articles
Both LOOKUP functions can be used to help you find specific data located in a database or list of data. The difference between the two functions lies in how your data is organized in your spreadsheets.
If the data is organized in columns, you would use VLOOKUP, if the data is kept in rows, you would use HLOOKUP.
For details on how to use the HLOOKUP function in your spreadsheets, including an example, read the article on the Excel 2007 HLOOKUP Function.
Related Articles
Comments
No comments yet. Leave a Comment