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
Submit an answer
