Does anyone have any suggestions to look at column A and:

In column A:
If Cell.Value = "005" Then
Colum B Cell Value="AAA"
In column A:
If Cell.Value = "102" Then
Colum B Cell Value="BBB"
In column A:
If Cell.Value = "109" Then
Colum B Cell Value="CCC"
In column A:
If Cell.Value = "112" Then
Colum B Cell Value="DDD"
In column A:
If Cell.Value = "641" Then
Colum B Cell Value="EEE"
In column A:
If Cell.Value = "2090" Then
Colum B Cell Value="FFF"

Any help would be greatly appreciated!


--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=511966