Automatic data selection

%3CLINGO-SUB%20id%3D%22lingo-sub-2400587%22%20slang%3D%22es-ES%22%3EAutomatic%20data%20selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2400587%22%20slang%3D%22es-ES%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3EI%20have%20a%20doubt%20with%20automatically%20table%20filling.%20In%20one%20hand%20I%20have%20different%20data%20associated%20with%20a%20product%20name.%20Then%2C%20I%20have%20to%20summarize%20all%20the%20data%2C%20filling%20the%20gaps%20with%20the%20value%20linked%20with%20each%20tag.%20Do%20you%20know%20any%20function%20than%20could%20search%20in%20each%20'order%20table'%20and%20put%20that%20value%20in%20the%20bif%20table%20in%20order%20to%20summarize%20all%20the%20data%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20link%20you%20the%20example%20in%20.xlxs%2C%20thank%20you!!!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Captura.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F285080iDEC1A407D459353A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Captura.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2400587%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2400699%22%20slang%3D%22en-US%22%3ERe%3A%20Automatic%20data%20selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2400699%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1060343%22%20target%3D%22_blank%22%3E%40EloyClement%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHere%20is%20a%20small%20example%20with%20Pivot%2C%20you%20can%20expand%20it%20as%20you%20like.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHope%20this%20information%20will%20help%20you%20further.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ENikolino%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi!

I have a doubt with automatically table filling. In one hand I have different data associated with a product name. Then, I have to summarize all the data, filling the gaps with the value linked with each tag. Do you know any function than could search in each 'order table' and put that value in the bif table in order to summarize all the data?

 

I link you the example in .xlxs, thank you!!!

Captura.PNG

2 Replies

@EloyClement 

Here is a small example with Pivot, you can expand it as you like.

 

Hope this information will help you further.

 

Nikolino

Al final lo he solucionado con la función BUSCARX, pero muchas gracias por la aportación!