Probblem with Mapping Cells
Hello in all of the course notes there is a problem in the mapping section there are some blank spaces I also have a question about the mapping. What is a good way to do it fast? I found a video on youtube of using Vlookup and that`s how I did it in the first course note but it takes quite a bit of time to do. And I faced some issues with Capitalized costs row it gave me #N/A when I tried to use the vlookup for it.
Hi MIroslav!
Great to hear from you. To be honest - this is an exercise, which always requires some time. You can save certain classifications performed in the past and do a VLOOKUP on these, but in most companies items will have different names and you will need to work on a case by case basis. What you can do to save time is to filter item by item when you classify to ensure you classify all items consistently.
Best,
Ned