Try something like this:

Put the XRef list of STORE_NUM and COUNTY into a separate list.

Example:
refs Col_Y Col_Z
Row_1 STORE_NUM COUNTY
Row_2 7545 Baltimore County
Row_3 7567 Baltimore County
Row_4 2612 Montgomery County
Row_5 2646 Montgomery County

Then.....if
C2: 7567

This formula returns the COUNTY associated with that STORE_NUM
L2: =VLOOKUP(C2,$Y$1:$Z$31,2,0)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Ms.shopalot" wrote:


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!