VBA- IF statement to replace cell contents

[arothacker]

Hello-

So I have three columns of data: Dept, Dept Desc, Location

What I'm trying to do is update the information in Dept Description if it matches criteria in the other two columns. If it doesn't match the criteria then leave as is.

For example,

If Dept = 3100 & Location = 111 Then Replace Dept Desc with "NY Warehouse"
Else If Dept = 3100 & Location = 211 Then Replace Dept Desc with "CA Warehouse"
Else Keep Dept Desc

Dept = Column E
Dept Desc = Column F
Location = Column G

I won't know the number of rows of data I will be working with either..

Any suggestions would be awesome! Thanks!