Does a function exist in excel to compare values between cells in the following way?
12345 56
23456
34567
Look into first column to find any number that has the last two digits that match the number in the second column. In this case 56.
12345 56
23456
34567
Look into first column to find any number that has the last two digits that match the number in the second column. In this case 56.