That should fix it. Thanks for your help,
Peanut

"Ron Coderre" wrote:

Your data isn't really structured for an efficient lookkup.

List it this way:
AZ____Pacific West
CA____Pacific West
HI____Pacific West
NM____Pacific West
NV____Pacific West
etc

Assuming that list in on Sheet2, A1:B26

This formula returns the region for New Mexico
=VLOOKUP("NM",Sheet2!A1:B26,2,0)

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"Peanut" wrote in message
...
It must be Monday. My brain isn't working this morning.

I have a list of states and the region that they are in. When I have a
customer, I want to simply type in the state and it will automatically
bring
up their correct region. Currently, my region data is by row:

PACIFIC WEST AZ CA HI NM NV
EAST CT DE FL GA

Can you help me come up with the correct value that will return "Pacific
West" when the value of CA is entered?

Thank you,
Peanut