Index match or collect

Options

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


Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!