Use the VLOOKUP function in the Region column of the Orders worksheet to return the region based on the two-character state abbreviation that is part of the code in the Ship To column of the Orders worksheet. Use the StateTable in the States worksheet.