Need Help Converting Data in Corresponding Cell.

[dmontez]

I have a sheet of data that has cities (Column C) and zipcodes (Column I).

I need to convert the city names that correspond with zipcodes 85044, 85045 and 85048 to read "Ahwatukee"

Thanks for your time and any help!

 

[gauntletxg]

You could put this in a helper column:

=IF(OR(I:I=85044,I:I=85045,I:I=85048),"Ahwatukee",C:C)

Drag it all the way down, then copy/paste the values and move the results to column C. Or in code:

Dim iLast As Long, i As Long
iLast = Range("I" & Rows.Count).End(xlUp).Row

For i = 1 To iLast
    Select Case Cells(i, 9).Value
    Case 85044, 85045, 85048
        Cells(i, 3).Value = "Ahwatukee"
    End Select
Next