13 May 2020 ... The formula must use INDEX and MATCH. Here's a picture of the array. enter image description here. The values I have to search for are ...
Understanding the logic of an Excel INDEX formula ... - Super User
This summary was compiled by our editorial team from publicly available information for quick reading. For full details, refer to original reporting where available.