HLOOKUP

HLOOKUP helps you perform data calculation and analysis in AirSheet / Worksheet. It provides the tools you need to look up and compute values with flexible parameters, making your work more efficient and helping you accomplish tasks with ease. With HLOOKUP, you can enter formulas directly in a cell or the formula bar, view automatic syntax prompts with parameter requirements and examples, use cross-worksheet references, build nested calculations, and get results that update automatically when source data changes. Whether you're writing a new lookup formula, checking syntax errors such as mismatched parentheses or missing separators, reviewing parameter usage, or manually recalculating when results seem incorrect, HLOOKUP helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53