I want to look at only the first 10 digits of the cells.
If the cells that are in column C equals to the cells in column G (but in another tab), then I want the result from column H(from same tab of G).
I tried with the VLOOKUP but it gives me the error.
The total number of digits in the cell is 11, so I don’t if it is easier to write to only look at first 10 or to say to not consider the 1st from right.
Example:
I have 11234567890 in one cell (C2) and 11234567891 in another (G2) with related item description(H2), I want have the same description for the item in G10 even if the last digit does not match.