Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In the figure shown below, column B contains some numbers representing a category to which a buyer belongs. Don't worry about what this means. The
In the figure shown below, column B contains some numbers representing a category to which a buyer belongs. Don't worry about what this means. The person who created this spreadsheet wants to place new category values in column C Column C should have if column B has It should have if column B has and so on as per the values on columns E and F The formula that will accomplish this for cell Cusing E:F as a lookup table and can be copied for the remaning cells in column C is
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started