Transfer excel column, depending on other columns value

Question

I have two excel sheets. Both have contact and send column. Contact columns have names and send columns have just yes or no values.

Column contact is populated in the both sheets. First table has unique contacts, but the second one can have some contact multiple times(multiple rows). (They have the same contacts).

Send column is populated in the first sheet(with unique contacts). I need to auto populate that column in the second sheet. The criteria is contact. If they are the same, value should just be copied.

Sample

Sheet 1:
1. contact1   yes
2. contact2   no

Sheet 2(before)
1. contact1   
2. contact1   
3. contact2
4. contact2

Sheet 2(after)
1. contact1   yes
2. contact1   yes
3. contact2   no
4. contact2   no

Andrew Wynn Andrew Wynn · Accepted Answer · 2016-12-05T12:32:10

You can use the VLOOKUP formula to do this. Here is Microsoft's tutorial on VLOOKUP. Read through that and you should be able to solve your problem.

If you are still having trouble though, come back and ask :)

Transfer excel column, depending on other columns value

1 Answers