Using multiple values to find another value

The first thing I did was change the data ranges on the Order Sheet and Code Sheet to Excel Tables because Excel Tables "know" how big they are, and they copy down formulas automatically. You can add new cods to the code table and not have to change the formula on the order table. When you add a new order number, it becomes part of the order table and the formula for the offering is copied down automatically.

Also tables allow you to address columns by header name which makes understanding the formulas easier and even helps with VB coding.

Since it is the combination of Country and Code that makes a record unique, I created a composite key as a helper column in the code table: =TRIM([@Country])&":"&TRIM([@Code]) - this is nothing more than the two strings concatenated together. I usually stick some sort of delimiter (in this case a colon) between the parts just to make it more human readable. Also in this case, I had to add TRIM because some of the country or code names have trailing or leading blanks.

On the Order Sheet, I look up the record using MATCH on the composite key and INDEX =IFERROR(INDEX(Table_Codes,MATCH(TRIM([@Country])&":"&TRIM([@Code]),Table_Codes[Composite],0),3),"No Offering")

Here is some more information on Excel Tables: http://www.utteraccess.com/wiki/Tables_in_Excel

I also recommend adding data validation (it copies down automatically in tables too) to check:
- the proper number of digits are added for the order number
- Use a drop-down list validation for country and Code
- Use a date validation for Start and End Dates

Establish the validation in the first row, and then Copy -> Paste Special -> Validation for the rest of the rows. Once every row has the same validation, it will be added automatically to all new rows from then on.

Here is information on data validation: http://www.utteraccess.com/wiki/Data_Validation