Adding data help

%3CLINGO-SUB%20id%3D%22lingo-sub-3192615%22%20slang%3D%22en-US%22%3EAdding%20data%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3192615%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20guys%20%2C%20hope%20you%60re%20doing%20great.%20i%20have%20a%20question%20for%20you%20that%20might%20be%20tricky.%20i%20want%20to%20add%20some%20data%20to%20a%20data%20base%20that%20hasn%60t%20that%20data%20(for%20percentage).%20If%20u%20can%20see%20below%20i%20have%203%20COMP%60s%20but%20only%20two%20of%20them%20are%20showing%20from%201st%20%2C%20the%20third%20one%20is%20showing%20from%202nd%20of%20the%20date%20but%20i%20have%20in%20the%20second%20screenshoot%20the%20PROD%20for%20all%20of%20them%20even%20for%20the%20COMPS%20that%20are%20not%20showed%20in%20data%20base%20%2C%20do%20you%20know%20a%20method%20so%20i%20can%20put%20the%20PROD%20into%20the%20data%20base%20even%20if%20the%20COMPS%20are%20not%20there%20%3F%20If%20you%20could%20help%20me%20that%20would%20be%20so%20great%20.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Andrei_Cocosatu_0-1645442166540.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349958i7528EB13B7365E84%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Andrei_Cocosatu_0-1645442166540.png%22%20alt%3D%22Andrei_Cocosatu_0-1645442166540.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Andrei_Cocosatu_1-1645442242379.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349959i51F8DDFE3141920F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Andrei_Cocosatu_1-1645442242379.png%22%20alt%3D%22Andrei_Cocosatu_1-1645442242379.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3192615%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3198228%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20data%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3198228%22%20slang%3D%22en-US%22%3Etry%20XLOOKUP%20between%20the%20two%20lists.%20If%20not%20found%20leave%20blank.%20You%20could%20try%20countif%2Fs%2C%20depending%20on%20what%20you%20need%20to%20bring%20back.%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello guys , hope you`re doing great. i have a question for you that might be tricky. i want to add some data to a data base that hasn`t that data (for percentage). If u can see below i have 3 COMP`s but only two of them are showing from 1st , the third one is showing from 2nd of the date but i have in the second screenshoot the PROD for all of them even for the COMPS that are not showed in data base , do you know a method so i can put the PROD into the data base even if the COMPS are not there ? If you could help me that would be so great .

Andrei_Cocosatu_0-1645442166540.png

Andrei_Cocosatu_1-1645442242379.png

 

 

1 Reply
try XLOOKUP between the two lists. If not found leave blank. You could try countif/s, depending on what you need to bring back.