How would I filter the data? That brings up a good point, from the answers
that I am tring to find. In the next column I would like Excel to pick one
of the answers based on the a round robyn list and who was picked last. Am I
going about this the wrong way. Should I combine the two and only get one
answer?

Thanks

"tompl" wrote:

Index will not pull all of the data related to one row in a table, it will
only pull one value. For Index to work you need one value to be selected
from the left column and one value from the top row.

Have you considered filtering you data to get what you want?

Tom