VBA learner ITG
Active Member
- Joined
- Apr 18, 2017
- Messages
- 267
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi Experts,
Please can i get your help as me and a coleaugue cant fathom a formul or VBA to undertake this.
I have a challenge where i have a text data table which is like below with up to 1000 text values and i am tyrying to look up a text value and return the value 1 or 2 in the adjacent column.
<tbody>
</tbody>
I have a column with unique cells and this looks like below:
<tbody>
</tbody>
<tbody>
</tbody>
Please can i get your help as me and a coleaugue cant fathom a formul or VBA to undertake this.
I have a challenge where i have a text data table which is like below with up to 1000 text values and i am tyrying to look up a text value and return the value 1 or 2 in the adjacent column.
PARTS AS PART OF A SINGLE JOB | FOLDER | |
<tbody> </tbody> | 1 | |
<tbody> </tbody> | 2 |
<tbody>
</tbody>
I have a column with unique cells and this looks like below:
UNIQUE CELL VALUE | FOLDER |
DUN249191 | |
DMF133 | |
DMH691 |
<tbody>
</tbody>
<tbody>
</tbody>