I'm comparing data from 2 different sources and looking for matches. I think the cell formatting must be different but I can't figure out how.
My equation is:
=LOOKUP(2,1/((TRIM(I2)=$C$2:$C$6)*(TRIM(J2)=$D$2:$D$6)*(K2=$E$2:$E$6)*(TRIM(L2)=$F$2:$F$6)*(M2=$G$2:$G$6)),$B$2:$B$6)
Notice the "TRIM" function is used in column I,J,L because the data from that source comes in with an extra space.
The equation seems right, as it worked when I typed in the data in the 3rd row.
Can someone give me any hints why the value in Cell O2 is not displaying properly?
See attached
Bookmarks