Seattle Sea Gear vlookup hlookup index shipping cost

Need help with a tutorial for a project. Need to use the State-Region table on the Region tab and the VLOOKUP function to identify correct region for each order. Place this information in Column N. Shipping data is based on three different methods: Truck, Rail, or Air. Use the HLOOKUP function and the first table on the Shipping tab to find the correct number reference for the shipping method. Place in Column P. Finally, apply name "Ship1" and "Ship2" to the two shipping tables to make referencing easy. Then use an INDEX function to decide shipping cost. In Column S, add shipping cost to total cost before shipping to find total cost after shipping.

© SolutionLibrary Inc. 9836dcf9d7