Lookup 2 data points then into a table to find the the relevant cell

Hi,

One way in D5

Formula:

=INDEX('Info Table'!$A$1:$H$8,VLOOKUP(B5,'Zone Data'!$A$3:$B$4,2,FALSE)+2,MATCH(C5,'Info Table'!A:A,FALSE))

But personally I'd change your basic data layout into a format that can be used by a Pivot Table and use a PT. with two Slicers to seelect Country and weight - See attached