Excel Formula Directory
Explore our comprehensive library of spreadsheet formulas with examples, use cases, and our interactive formula generator.
Showing 5 formulas in Lookup & Reference
HLOOKUP
=HLOOKUP("Apple", A1:E3, 3, FALSE)Looking up a value in the top row and returning a value from a specified row
View formula detailsINDEX
=INDEX(A1:D10, 3, 2)Returning a value from a table based on its position
View formula detailsLOOKUP
=LOOKUP(90, A2:A20, B2:B20)Finding an approximate match in a sorted range or two arrays
View formula detailsMATCH
=MATCH("Apple", A1:A10, 0)Finding the position of a value in a range
View formula detailsVLOOKUP
=VLOOKUP("Smith", A1:D20, 3, FALSE)Looking up a value in the first column and returning a value from the same row
View formula detailsCan't find the formula you need?
Use our AI-powered Formula Generator to create custom formulas for any task. Simply describe what you want to calculate in plain language.
Popular formula requests:
- Calculate the sum of values when multiple conditions are met
- Extract specific text between two characters
- Look up values across multiple sheets with fallback options
- Calculate business days between two dates excluding holidays
Unlock the Full Power of Sheet Alchemy
Get access to all our formula generators, script generators, and conversion tools with a free Sheet Alchemy account.