STEVEB Wrote:
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!

Instead of VBA you could have a nested IF formula in B1

=IF(A1="005","AAA",IF(A1="102","BBB",IF(A1="109"," CCC",IF(A1="112","DDD",IF(A1="641","EEE",IF(A1="20 90","FFF",""))))))
And then autofill to all the cells (B2 onward) in col B.

I am assuming that col A has text characters not numbers. eg if A1
="102" then B1 = "BBB" asssumes A1 is character string. If it is number
then change formula by removing quotes around A1 value. eg A1=102
instead of A1="102"

A V Veerkar


--
avveerkar
------------------------------------------------------------------------
avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338
View this thread: http://www.excelforum.com/showthread...hreadid=511966