Support Board

Date/Time: Sun, 29 Dec 2024 14:15:53 +0000

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

[2015-12-27 15:45:25] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4143
If you change K3 to =F3, which makes it not ordered, the New vs Old is about the same. Will GETCORRESPONDINGMATCH be able to be used to like this: =AVERAGE(GETCORRESPONDINGMATCH(...):GETCORRESPONDINGMATCH(...)) to locate 2 rows and average everything in between in the ReturnResultColumn? Will GETCORRESPONDINGMATCH be able to use TRUE as a SearchNumber? What will GETCORRESPONDINGMATCH return if there is a duplicate SearchNumber in the SearchColumn? Will there be row range parameters within SearchColumn and ReturnResultColumn? GETCORRESPONDINGMATCH is lengthy. How about VGET instead. Maybe it would be easier to optimize MATCH than to build a new function.