hey guys help me out here please
i have a list with salesman, state and county
another list with salesman, state and county except on this list the salesman is empty.
i need to find how to match the state with state and county with county to find the right saleman. the problem is some county names are the same so i need to match BOTH to get the right salesman. how do i do that?
heres an example:
spreadsheet1
STATE County salesman
AZ Jefferson Alex
AZ Phoenix Frank
NJ Burlington Bob
NY Queens John
TN Wayne Dan
TN Blanco Ed
TX Blanco Jay
spreadsheet2
STATE County salesman
AZ Jefferson
NY Jefferson
NY Queens
TN Blanco
TX Blanco
Thanx for any assistance you guys give =]
i have a list with salesman, state and county
another list with salesman, state and county except on this list the salesman is empty.
i need to find how to match the state with state and county with county to find the right saleman. the problem is some county names are the same so i need to match BOTH to get the right salesman. how do i do that?
heres an example:
spreadsheet1
STATE County salesman
AZ Jefferson Alex
AZ Phoenix Frank
NJ Burlington Bob
NY Queens John
TN Wayne Dan
TN Blanco Ed
TX Blanco Jay
spreadsheet2
STATE County salesman
AZ Jefferson
NY Jefferson
NY Queens
TN Blanco
TX Blanco
Thanx for any assistance you guys give =]