I have two tables in my document looking like this:
Serial Number Table (in formula : SNT):
Product Technical Specification (in formula: PTS):Please Login or Register to view this content.
and the goal is to list every serial numbers associated to a product that needs labeling and their product number and power:Please Login or Register to view this content.
So I tried to write my own Index/Match formula and it somehow wont filter the items that shouldn't be labeled. The formula looks like this:Please Login or Register to view this content.
My result is:Please Login or Register to view this content.
I might have made my match a bit overly complicated but these tables are over different sheets and I do not know any better to see if labeling is 1 or 0. And to be honest, I've been looking around for an explaination of what MATCH(0,1,0) is doing exactly and couldn't find anything. How can the range be 1 and the value looked up 0?Please Login or Register to view this content.
Thank you for any help!=IFERROR(INDEX(SNT[Serial number];MATCH(0;COUNTIF(A$1:$A1;SNT[Serial number])+IF(INDEX(PTS[Labeling];MATCH(INDEX(SNT[Product model];MATCH(INDEX(SNT[Serial number];SNT[Serial number]);PTS[Product model];0))<>1;1;0);0));"")
Bookmarks