alinka
Board Regular
- Joined
- Oct 30, 2002
- Messages
- 70
Hi excel geniuses!
I have a problem. I have a list which has a state, region, industry and assigned person for each state/industry.
The list goes like this:
STATE REGION FINANCE RETAIL MANUF
AL EAST Jack Joe Michelle
CA West Ken Ken Ken
Then I have a separate sheet where there's a column for a company name, state code, and industry.
What I want to do is add another column with Assigned Person based on the two factors: STATE and INDUSTRY.
How can I do this quickly? Is there a way to automate this? THANKS SO MUCH
I have a problem. I have a list which has a state, region, industry and assigned person for each state/industry.
The list goes like this:
STATE REGION FINANCE RETAIL MANUF
AL EAST Jack Joe Michelle
CA West Ken Ken Ken
Then I have a separate sheet where there's a column for a company name, state code, and industry.
What I want to do is add another column with Assigned Person based on the two factors: STATE and INDUSTRY.
How can I do this quickly? Is there a way to automate this? THANKS SO MUCH