Data Summary Output (Database or Lookup and Reference)

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

Example.xlsx

Output is tab "ouput", data is tab "data"

I need to build a flexible formula that, as is constructed now, returns Tom in cell B2, John in C3, etc., and needs to be flexible enough so that if i change any of the inputs in the data tab, the output tab will correctly change

Thank you for your help