What is VLOOKUP?
VLOOKUP (Vertical Lookup) is one of the most-used functions in Excel and Google Sheets. It’s used to search for a particular value in a vertically organized table or data set. It returns values from the columns to the right of the one containing the values to lookup. VLOOKUP takes four arguments:
To search a horizontally-structured data set, use HLOOKUP.
Learn how to use GRID's AI Assistant
So, what is GRID exactly?
GRID is a magical, all-in-one surface transforming the way teams work with spreadsheets. Our built-in document layer makes for beautiful data visualization and presentation, and our AI Formula Assistant makes writing formulas a breeze.
Get started in GRID Sheets or connect other data sources like Notion databases, Airtable bases, Google Sheets and Excel.
Add display & interaction elements to your GRID doc. Then pull data from one or more sources to build your financial projection, ROI calculator, or quarterly board report. Easy!