Bank data is stored in a database that separates and stores customer information into different tables depending on data field relevance. In this assignment file, Download In this assignment file, you have customer data retrieved from 3 tables and stored in 3 different worksheets. Customer personal information in the Customer worksheet, results of promotion in Promotion, and data about the customer car in Car worksheet.

You are going to create a sampling tool for data analysis. This is a worksheet where you enter the customer ID for automatic retrieval of customer data from the other 3 worksheets.

1..Create a sample of 14 customers. Enter customer IDs in Column A of 150, 250 ,350, 450, 550, 650, 750, 850, 950, 1050, 1150, 1250, 1350, for demonstration.

2.. Create named ranges to address information within each sheet. (ie... Customer, Promotion, Car)

3..Create your LOOKUPS in the Information worksheet. Create LOOKUP formulas in columns B through S to retrieve each customers data. You should be able to enter formulas only in the first row and copy them down in columns.