Question: In SKU Classification, instead of using the VLookup function ( the formulas in column I ) , we can use the If function to get
In SKU Classification, instead of using the VLookup function the formulas in column I
we can use the If function to get the same result. Research how to use this function in
Excel help Pressing F in Excel will bring up the help window Make a copy of the
worksheet Database In the copied worksheet, remove the Vlookup functions in
column I, and classify SKUs again by using IF Function. Hint: the formula in Cell I
should be IFHAIFHBC Compared with the VLookup
statement, is the nested If statement a more flexible way or not? Why?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
