Comparing a string with all values in a range

[ajuece19]

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.

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.

 

[MarktheMacroman]

You need to loop through your table looking at the type column, comparing values to the one you are looking for. Use the value of the loop, to pull the adjacent value from the column code once the loop has matched. For example, For x = 1 to 10 looking = cells(x+1),1) if looking = "the value you are looking for" then thecode = cells(x+1,2) next note: I have assumed that table is sat at the top left of a sheet, so hence row 1 is the headers, so that is why I added 1 to the loop value x to start looking at row 2.