Adding data help

Copper Contributor

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.