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 ...