Good day all clever ones, i believe i might have a thinker here.
I am struggling with something. I have over 3000 cells, like the below, each with a different code and here below is what i want to do. I want excel to "scan" from A2-A3002 in B2-B3002 respectively. The results in column B must be a description(Which i obviously have to create a data base, like for instance "ANL-Air cooled chiller" and then ANL***P-Air cooled chiller with low head pump)
<tbody>
</tbody>
Please let me know. I really do not want to type(copy paste) everything over 3000 times
I am struggling with something. I have over 3000 cells, like the below, each with a different code and here below is what i want to do. I want excel to "scan" from A2-A3002 in B2-B3002 respectively. The results in column B must be a description(Which i obviously have to create a data base, like for instance "ANL-Air cooled chiller" and then ANL***P-Air cooled chiller with low head pump)
Unit | Description |
ANL020 | Air cooled chiller |
ANL020P | Air cooled chiller with low head pump |
ANL020A | Air cooled chiller with low head pump and buffer tank |
ANL020H | Air cooled heatpump |
ANL020HP | Air cooled heatpump with low head pump |
ANL020HA | Air cooled heatpump with low head pump and buffer tank |
ANL030 | Air cooled chiller |
ANL030P | Air cooled chiller with low head pump |
<tbody>
</tbody>
Please let me know. I really do not want to type(copy paste) everything over 3000 times