I have 2 worksheets:
- Worksheet 1 with Column H need to find a match on
- Worksheet 2 with Column F
If a match is found, I need to copy the contents of worksheet 2 column g to worksheet 1 column E.
user1 user2 user3
Sheet 2 ( 2 different columns)
red user2 white user1 blue user3
So compare user 1 to users in 2nd table when matching user 1, copy "white" to a column in the same row as user 1 on the first table.