Login Page - Create Account

Support Board


Date/Time: Sat, 04 May 2024 01:27:09 +0000



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

[2018-11-06 19:25:43]
User345323 - Posts: 18
Hello tomgilb, thank you for your reply.
Your first function doesen't work correctly for my needs, because if I search AC1=6, result is row 9 and not row 4.
Second function works correctly but in the same way as GETCORRESPONDINGMATCH, looking from ROW 3 to ROW 9.
What if I need to look from ROW 9 to ROW 3?

Thank you