I need help with a formula. I dont know how to do a Macro so hopefully
someone can help me without me getting completely confused! I am going to get
somewhat specific because I dont know how else to explain what I am needing
help with! Thanks so much in advance!

Here is my dilemma:

I have Column C set up as store numbers. However, I have Column L set up to
represent the County that the store is located. I need to have a way to
return L automatically depending on the store # that is inserted into column
C. This is going to be huge because I have 63 stores (Column C) and about 10
different counties (column L)! The below is what I started with but I dont
know how to formulate this!

If column C1 has €œ7545€� or €œ7567€� then column L1 = €œBaltimore County€� but
if Column C1 has €œ2612€� or €œ2646€� then column L1 = €œMontgomery County€� (etc,
etc!)


HELP PLEASE!!!! Ahhhh!