I'm trying to get the FGT result looked up from the 2nd sheet if the article Nr match.

I tried this

=INDEX(...), MATCH([Article NR]@row, {.....}, 0))

But it gives me only the correct result, when only 1 article Nr is entered in sheet 2.

How can I check all article Nr in sheet 2. I tried to combine HAS but I failed.

I also have the articles numbers separated( 3 column for 3 article Nr instead only 1) if this helps.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!