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...
Does it need to be all in general? the code contains Letters and numbers and set as General.
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.