Login Page - Create Account

Support Board


Date/Time: Fri, 12 Dec 2025 17:12:06 +0000



Post From: Basic Examples of How You Use INDEX, MATCH / Spreadsheet Performance Improvements Now Available

[2015-12-16 15:06:36]
Sawtooth - Posts: 4299
In Excel, HLOOKUP and VLOOKUP require the lookup row/column to be in ascending order, hence the need for INDEX/MATCH.

I will post again with examples of how I use (or would use) these functions.