I have a table that will be linked to from another worksheet. It will have 64 columns. I need to pull the data points from each line item into an equation on this other worksheet. For example if the unique combination of criteria 1 AND criteria 2 AND criteria 3 = column 5, then the formula will pull from that column.
I'll have data validation "DV" drop downs for each criteria on the other sheet. Based on these 3 selected values, I'll need logic to identify the column.
Once I have column, I'm thinking of using the DGET function with the table below as the database range to pull in the data points for the math that needs to happen next. The data points in the table will be rates which will be applied to volumes to compute dollar amounts on this other sheet. Although I'm not sure that will work. An HLOOKUP might be a better solution.
Here's the matrix for the total columns required:

country products network cost type columns
US 9 2 2 36
Canada 4 2 2 16
Europe 3 2 2 12
total columns 64

Th table starts w/ the US and has 36 columns, followed by Canada w/ 16 and so on . . .


column number 1 2 3 4
country US US US US
product A B C D
network and cost type X Std X Inc Y Std Y Inc
Line item 1
Line item 2
Line item 3

Thanks in advance for any insight on the "optimal" approach