Hi Guys,
I have data in Column A and Column B, I need to check the last Five digits of Column A in Column B last Five digits.
Can anyone help to get the formula.
<colgroup><col><col></colgroup><tbody>
</tbody>
Ex: Column A cell A1 "59782" to check in Column B if found return yes
I have data in Column A and Column B, I need to check the last Five digits of Column A in Column B last Five digits.
Can anyone help to get the formula.
Column A | Column B |
80059782 | CFQ0060068 |
80059874 | CFQ0059919 |
80059875 | CFQ0059918 |
80059891 | CFQ0059915 |
80059892 | CFQ0059892 |
80059915 | CFQ0059891 |
80059918 | CFQ0059875 |
80059919 | CFQ0059874 |
80060068 | CFQ0059782 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Ex: Column A cell A1 "59782" to check in Column B if found return yes