Hi,
The formula in N24 does not need to be an array formula.
You are using MATCH(L37,abc[VOUNO],0) so that finds the exact match.
Thus it will return the index for the first value found where L37 = abc[VOUNO], being 13. So the index part will always return 2017, since [VOUNO] with the value 195789 appears twice in your table.
Is it an error in the table, or do you need another formula to handle this scenario?
EDIT: possible like formula in file to handle 2 or more occurrences of [VOUNO] in table abc. Perhaps you'd need to do the same for table def.