Support Board

Date/Time: Sat, 11 May 2024 11:05:09 +0000

Post From: I'm not able to make GETCORRESPONDINGMATCH spreadsheet function to works

[2018-11-05 20:50:02] Link To Thread - Link To Post [Go To First Post]
User345323 - Posts: 18
I'm sorry, I get my error. I undrestood in a wrong way "SearchRangeOrderingFlag" field. That's not how to search, from top to bottom of range or viceversa, but how data are ordered, so I've to insert "0" value because my search column is unordered. So if I use a "0" in this field I've same result as a combination of INDEX and MATCH functions, looking for result from TOP to BOTTOM of range. But, how to search column from BOTTOM to TOP of range? Any help please? Date Time Of Last Edit: 2018-11-05 20:50:39