Is there a way to use VLOOKUP and have it ignore the first digit in the column it's searching?
I'm searching for a 10 digit number in an 11 digit column, and the first number is usually not important.
Even better, would be an IF option that would say, if it's over 10 digits, ignore the first digit.
I'm searching for a 10 digit number in an 11 digit column, and the first number is usually not important.
Even better, would be an IF option that would say, if it's over 10 digits, ignore the first digit.
Last edited:
