Hi,
I need to put a formula in Column M which will search through column L and match it (partially or completely) with column O and display the value available in same row in column P. If VBA code will do it faster then provide VBA code please.
e.g. in Column L, it is written as "Salary of Emp#784" so in Column M it should be just "Salaries"
<colgroup><col span="2"></colgroup><tbody>
</tbody>
Thanks,
Imran.
I need to put a formula in Column M which will search through column L and match it (partially or completely) with column O and display the value available in same row in column P. If VBA code will do it faster then provide VBA code please.
e.g. in Column L, it is written as "Salary of Emp#784" so in Column M it should be just "Salaries"
Column O | Column P |
Donation | Donations |
salary | Salaries |
Commerce | Legalization |
Housing | Housing Allow. |
Bank | Bank Charges |
GSM | Communications |
Stamp | Legalization |
Trip | Business Trip |
Chamber | Legalization |
<colgroup><col span="2"></colgroup><tbody>
</tbody>
Thanks,
Imran.