Index match or collect
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
Help Article Resources
Check out the Formula Handbook template!