1) Sales Data Define the range name for each row of data as the month, and the name for each column of data by the product. Use the VLOOKUP, MATCH and INDEX functions to search for a specific sales value 2) A B D E Month January February March April May June July August September October November December 7792 7268 7049 7560 8233 8629 8702 9215 8986 8654 8315 7978 5554 3024 5543 5232 5450 3943 5991 3920 4753 4746 3566 5670 Product C 3105 3228 2147 2636 2726 2705 2891 2782 2524 3258 2144 3071 3168 3751 3319 4057 3837 4664 5418 4085 5575 5333 4924 6563 10350 8965 6827 8544 7535 9070 8389 7367 5377 7645 8173 6088 Using VLOOKUP() + IF(). Sales Lookup Month Product April E Sales