Google Sheets Formula Directory
Explore our comprehensive library of Google Sheets formulas with examples, use cases, and our interactive formula generator.
Showing 5 formulas in Lookup & Reference
HLOOKUP
=HLOOKUP("B", A1:C3, 2, FALSE)Searches for a value in the top row of a range and returns a value from a specified row below in Google Sheets.
View formula detailsINDEX
=INDEX(A1:C3, 2, 3)Returns a value or reference from a range at a specified row and column position in Google Sheets.
View formula detailsLOOKUP
=LOOKUP(5, A1:A3, B1:B3)Searches for a value in a range and returns a corresponding value from another range in Google Sheets.
View formula detailsMATCH
=MATCH(5, A1:A5, 0)Returns the relative position of a value in a range in Google Sheets, useful for lookups.
View formula detailsVLOOKUP
=VLOOKUP(5, A1:B3, 2, FALSE)Searches for a value in the first column of a range and returns a value from a specified column in Google Sheets.
View formula detailsFormula Generator
Create custom formulas with our AI-powered tool
Can't find the formula you need?
Use our AI-powered Formula Generator to create custom Google Sheets 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
Transform Your Spreadsheet Experience
Join thousands of users revolutionizing their data workflows. Get access to premium tools and expert knowledge.