What is INDEX & MATCH?
INDEX & MATCH is the power couple your formulas need. This super flexible combination of functions lets you work with multiple criteria and is the best way to perform left-lookup, two-way lookup, closest match and much more.
INDEX: The INDEX function shows a value or cell reference from a specific range.
MATCH: This function identifies the row position of a value within a single range of cells.
Learn how to use GRID's AI Assistant
So, what is GRID exactly?
GRID is the smart surface for working with numbers
GRID is a magical, all-in-one surface transforming the way teams work with spreadsheets. Our built-in document layer makes for beautifully interactive data visualizations and presentations. Plus, you’ll breeze through formula writing with our AI Formula Assistant.
Add display & interaction elements to your GRID doc, then pull data from one or more sources to build your financial projection, ROI calculator, quarterly board report and more.