Formula for same code

[NerakSeven]

For the same code in sheet ‘A’ and Sheet ‘B’ i need the Length value be a major than 0 and equal to value of cell in sheet ‘A’ for example

• In sheet ‘A’, put Code “eac” and length = 125.
• In sheet ‘B’, put this:

Code	Length
eac	100	ok
eac	25	ok
eac	25	ok

<tbody>
</tbody>

This code below only works when code “eac” in sheet ‘A’ is in A2 but when I put in another cell the formula not works

=IF('A'!$C4:$C152=C4;'A'!$M4:$M152>=O4;O4="")

Regards

 

[NerakSeven]

Maybe is another way to do that, someone can help me?

 

[NerakSeven]

please