What is VLOOKUP?
VLOOKUP means vertical lookup. It searches the first column of a selected table and returns a value from a chosen column number in the same row. It is often used to find email, department, rent amount or asset owner based on a key.
What is HLOOKUP?
HLOOKUP means horizontal lookup. It searches the first row of a selected table and returns a value from a chosen row number. It is useful when your headers are arranged across columns and values are below them.
Business examples
Use VLOOKUP to match employee code to email. Use HLOOKUP when month names are placed across columns and you want to return the value under a selected month. Use both carefully when preparing billing or license reports.
Limitations
Both formulas depend on stable table ranges and correct index numbers. Hidden spaces, duplicate keys and wrong match settings can cause incorrect results. For audits, use duplicate checks and missing-record reports before finalizing action.
ReconNimble approach
ReconNimble focuses on the business question first: what is missing, what matched, what is duplicate and what action should be taken. The Formula Logic tab explains when VLOOKUP or HLOOKUP-style logic was used.