Forum Discussion

Sandra_V670's avatar
Sandra_V670
Copper Contributor
Apr 18, 2023

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...
excel
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Apr 18, 2023

Sandra_V670 

One possible reason for this could be that the data types of the value returned by the LEFT function and the data in the array you are searching with the MATCH function do not match.

The LEFT function returns a text value, so if the array you are searching with the MATCH function contains numbers or dates, you may need to convert the text value returned by the LEFT function to a number or date using the VALUE or DATEVALUE functions before using it in the MATCH function.

 

Could you provide more details about your formula and the data you are working with?

Sandra_V670's avatar
Sandra_V670
Copper Contributor
Apr 18, 2023
Does it need to be all in general? the code contains Letters and numbers and set as General.
    • Sandra_V670's avatar
      Sandra_V670
      Copper Contributor
      Apr 18, 2023

      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.

Resources