I have a spreadsheet that in one column will hold a person's name and in
another column it will hold their region number that the person is
responsible for. Once I type in the name, is it possible for Excel to
somehow look at the next tab for the number that corresponds with the name?
I would prefer to do this in Access, but my boss does not want it done that
way.

If someone could tell me if this can be done and help lead me in that
direction, I would appreciate it.

Thanks.