I would upload an attachment, but the workbook I am using contains a lot of confidential information (I am using it for my job).

If the example I gave was too hard to understand, I will try to ask a simpler question.

I have an array, for instance {1, 4, 5, 7, 7, 7, 9}. I want to use each of those values to pull data from the corresponding rows. So I want to pull data from cells F1, F4, F5, F7, F7, F7, F9. That is why I was hoping to use the array {1, 4, 5, 7, 7, 7, 9} in an INDEX function. I could do something like =INDEX(F1:F9, {1, 4, 5, 7, 7, 7, 9}). But this doesn't work. Can you not use multiple values in the INDEX functions row_num argument? If not, are there any other ideas of how to take an array of values and use them to point to row numbers in a column to get those values?