There were only 100+ rows in example database sheet. Manually adding macro categories(aka mapping) was easy for such smaller data set. However, real world might have much bigger data sets, how should we do mapping there ? It would have been good to see automatic mapping instead of manually doing it. Is there a way to do it ?

Hi Vipin, You can't really do automatic mapping if you haven't done it at least once before. If you have done this exercise for a previous year, then you can do a VLOOKUP (or INDEX&MATCH) to transfer some of the corresponding values. This can't be done automatically the first time though. Best, Ned

I use =si.conjunto, which I think in english is =ifs, for example: For example: =SI.CONJUNTO(C5="Core business revenues","Net Sales",C5="Other revenues","Other revenues") etc. It can be made even more automatic if instead of typing C5="Core business revenues", you place all the P&L Accounts in an array of cells as placeholders, and when typing the formula you reference those placeholder cells, so you would be typing C5=$A$1 (supposing A1 has "Core business revenues" as its text value).

Follow this topic

Vipin Gupta

Last answered:

09 Jan 2023

Posted on:

19 Apr 2021

Alternative to manual mapping ?

in Introduction to Excel / Mapping the Rows in the Database Sheet

2 answers ( 0 marked as helpful)

Ned Krastev

Instructor

Posted on:

19 Apr 2021

Jesus Chavez Erhard

Posted on:

09 Jan 2023

Alternative to manual mapping ?

Submit an answer

related questions