Lookup Intersection Of Values?

I am trying to create a table that references data in a much larger report that constantly has rows and columns added and deleted off of it. Here is an example:

---------------Juice Sell In-----Desert Sell in-----Total Sales

James--------34%---------------8%---------------22
Frank---------22%---------------2%---------------18

This is a simple example of what I would be trying look data up from. But there are hundreds or rows and columns in the actual report, so I am creating another document that just pulls the data I need to review off of the larger report. New rows and columns are added to the report on a daily basis. So I am trying to have a cell return a value as a result of an intersection of 2 other values that remain constant. For example: Looking up the intersection of the row that contains "James" and the column that contains "Total Sales" would return "22" as the result in the cell.