Login Page - Create Account

Support Board


Date/Time: Sat, 10 May 2025 07:32:04 +0000



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

[2015-12-16 15:06:36]
Sawtooth - Posts: 4214
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.