I've been having the hardest time figuring this out. Maybe someone here could
help?

A column in my table has a series of city names. I have another table on a
different worksheet that allocates each of these cities to an area e.g.
Petaluma (city) = Northern Marin (area). I want to write a formula that
converts the city name on each row to the appropriate area.

I'm guessing this could be done with an IF and OR formula, but it would
probably be better if I could write that formula to look up my city/area
allocation on the other worksheet.

Remember: I'm dealing with names, not numbers. Is all of this even possible?
If so, how?

Thanks for your help.