Below file gives sales of four different Verizon phones in five regions.
able[[,Nokia,Samsung,Kyocera,],[East,Motorola,400,450,],[West,100,300,150,190],[South,90,110,230,250],[North,200,220,310,350],[Canada,270,290,50,75]]
Fill the below table following below directions:
In Column "Region", use formula OFFSET to retrieve region information based on "Row" (column B).
For example, Row 1 returns east, and row 2 returns west.
In Column "Phone", use formula OFFSET to retrieve phone information based on "Columns" (column C).
For example, column 1 returns Nokia, and Column 2 returns Motorola.
In Column "Sales", use formula Index to retrieve specific sales information of this region and phone.
Row
Row
able[[Columns,,,Phone],[1,1,100,],[2,1,,],[3,1,,],[4,1,,],[5,1,,],[1,2,,],[2,2,,],[3,2,,],[4,2,,]]
1
Below file gives sales of four different Verizon phones in five regions: Nokia, Motorola, Samsung, Kyocera.
East: 100, 300.
West: 90, 110.
South: 200, 220.
North: 270, 290.
Canada: 100, 90.
Kyocera: 400, 150, 230, 310, 50.
Samsung: 450, 190, 250, 350, 75.
Fill the below table following below directions:
1) In Column "Region", use formula OFFSET to retrieve region information based on "Row" (column B). For example, Row 1 returns east and row 2 returns west.
2) In Column "Phone", use formula OFFSET to retrieve phone information based on "Columns" (column C). For example, column 1 returns Nokia and Column 2 returns Motorola.
3) In Column "Sales", use formula Index to retrieve specific sales information of this region and phone.
Row
Columns
Region
Phone
Sales
1
1
12222