View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peanut Peanut is offline
external usenet poster
 
Posts: 34
Default Return value from a list

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