formula

Christine Menke

Hi,

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.

Thanks

Paul Newcome

If you have sheet 2 set up so that it has all article numbers in a multi-select dropdown then you could use something along these lines...

=INDEX(COLLECT({Sheet 2 FGT Column}, {Sheet 2 Article # Column}, HAS(@cell, [article Nr]@row)), 1)