On one worksheet, I have a list of names (text) in column C (C2:C248). In Columns I and J (rows 2 through 248, again), I have two different ways to categorize the names in Column C (for arguments sake, lets just say that Column I could contain numbers 1-10 and Column J would contain letters A-R).

In a separate output worksheet, I have a matrix set up with top row (row 1) containing numbers 1-10 and the left most column (column A) containing letters A-R. I am trying to build a formula that will populate this matrix.

As an example, if the entry in cell C125 was John Smith, I125 was a 5 and J125 was a B, then in my output matrix, I would want cell F3 to return "John Smith"

My initial thought was to use an index function, but I'm not sure how to return the correct row reference...I had also thought about DGET, but I don't think my data is set up correctly

Any help would be greatly appreciated