I am trying to make a counter using a match function. The below formula is what I was using, and it works fine, but I am needing the MATCH to look for multiple arguments. I tried an OR function but it returns an error.
=IFERROR(MATCH("X",OFFSET('Unit Data'!$C$2,0,$A$8-1,COUNTA('Unit Data'!$C:$C),1),0),"")
I tried an OR function, as shown below, but it doesn't work. How do I fix this?
=IFERROR(MATCH(OR("X","Y","Z"),OFFSET('Unit Data'!$C$2,0,$A$8-1,COUNTA('Unit Data'!$C:$C),1),0),"")
=IFERROR(MATCH("X",OFFSET('Unit Data'!$C$2,0,$A$8-1,COUNTA('Unit Data'!$C:$C),1),0),"")
I tried an OR function, as shown below, but it doesn't work. How do I fix this?
=IFERROR(MATCH(OR("X","Y","Z"),OFFSET('Unit Data'!$C$2,0,$A$8-1,COUNTA('Unit Data'!$C:$C),1),0),"")