What is the purpose of the HLOOKUP function in Excel 2007? The HLOOKUP if a "horizontal" lookup formula that: needs to know what number you want to look up, where to look it up like a table or range so it can compare with an equal or greater than value, and then to return that comparative value from a row you specify. Confused yet? Okay, if you're like me you watch training videos because they're a quick and effective way of getting information. So I recommend watching my Excel 2007 training videos. In short, the HLOOKUP is typically used to lookup things like numbers in huge spreadsheets and make comparisons to return the value desired!

Purchase the training video and you can see this in action for yourself!