Dears
In column A I have list of unique codes and I want to get the code based on input of last 4 characters of the code. Please help me to get a formula.
e.g., There is a code in cell A5, which is 80007458 and in input cell when I enter 7458, I should get the full code in result cell.
Theoretically the equation should be
INDEX (A1:A100, MATCH (input value, RIGHT (A1:A100,4),0))
Thank you
In column A I have list of unique codes and I want to get the code based on input of last 4 characters of the code. Please help me to get a formula.
e.g., There is a code in cell A5, which is 80007458 and in input cell when I enter 7458, I should get the full code in result cell.
Theoretically the equation should be
INDEX (A1:A100, MATCH (input value, RIGHT (A1:A100,4),0))
Thank you