Forum Discussion
LEFT FUNCTION RESULT CANT READ BY MATCH
Hi, Would like to ask some assistance from here. I first did a formula for LEFT function and I got the correct value. But when i used that cell in my match function, it appears error. I manually typ...
Please include the following info to help others answer your question:
Thank you NikolinoDE . The look up value contains numbers and letters but when I apply the LEFT Formula, numbers will only be left as data. The data format is in general. I got the right value Im looking for after LEFT but when I do match function and uses the DATA reslt in my LEFT function, it appears error.