Registration date
October 22, 2018
Last seen
October 22, 2018
Contributions
2
Gender
Female
Location
Tampa, UNITED STATES OF AMERICA

Comparing two columns using partial match logic [Solved/Closed]

I need a bit of help please. I have 2 columns of data that I am doing a partial match compare (first 15 positions) using a formula in column AA. My formula is as follows =IF(MATCH("*"&LEFT(D2,D15)&"*",$Z$Z2:$Z$432,0)," ",D2) Net is that I am checking the first 15 positions of column D row 2 and if there is a match I want colu...