I have a sheet with two columns "type", "code" with some values. The "type" column contains unique values. But the "code" contains values which categorize the values in "type" column.
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
types 1,5,7 are mapped to the code "a" ... it goes like this.
Now i have a string stored in a variable in my code which will return a "type". Now i need to look up this table and see the "code" of the corresponding "type" returned and store it in another variable.
Not sure i have explained it correctly. I am very new to VBA coding. Please help me out.
type | code |
1 | a |
2 | c |
3 | f |
4 | c |
5 | a |
6 | b |
7 | a |
8 | e |
9 | g |
10 | d |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
types 1,5,7 are mapped to the code "a" ... it goes like this.
Now i have a string stored in a variable in my code which will return a "type". Now i need to look up this table and see the "code" of the corresponding "type" returned and store it in another variable.
Not sure i have explained it correctly. I am very new to VBA coding. Please help me out.