Module 06

Feedback:

This assignment was hard because there were so many small factors, details, and adjustments that would affect if the outcome was correct or resulted in an error. A few new things I learned were freezing certain rows, new formulas to use, and to keep a critical eye for detail. I am still unsure of my results because I found that there were subtle differences in the assignment directions and the example spreadsheet from the reference website. For example, the directions called to start the new chart for produce on A12, but it appears that on the sample chart on the reference website that the produce chart begins on B12. Also, the produce examples we were supposed to use (P50, P45, P32, P52, P22) did not fill up the spaces completely between the start of the chart to the calculations for the total, shipping, and sales tax, which began on E21. Another part of the assignment I did not manage to perfect was getting the City/Postal Code in the same box. Although I managed to pull up both the values from the CUST sheet, they appeared in two separate boxes. I initially used the function =(VLOOKUP($C$5,Customers!A1:E101,{4,5})), but it did not return both values for some reason until I adjusted it to the function =ArrayFormula((VLOOKUP($C$5,Customers!A1:E101,{4,5}))).