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 $12$ customers.$$ Enter customer IDs in Column A of $100,200,300,400,500,600,700,800,900,1000,1100,1200,1300,1400.$

$2..$ Next, create named ranges for 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 customer$$s data.$$ You should be able to enter formulas only in the first row and copy them in columns.