Index match or collect


HI Experts,

I try to set up a formula for below table.

Blue Part is on another sheet, and I would like to show the correct awbif article is the same and "Name" is "Kerstin" in the yellow marked column "awb new sheet".

I tried a few versions with Index and Match or collect, but without success.

Would be great if you could help me here.

Thanks in advance


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!