This video post will teach demonstrate how to nest formulas in Excel. I share how to use an IF function to determine which table to gather data from using a VLOOKUP. If the region has 2 characters, then lookup the United States data table, otherwise lookup and reference the international table.
Practice on your own with my logical-nested-formulas.xlsx.
Download my Excel keyboard shortcuts guide here.