Copy cell from another sheet where cell is value...?
Solved/Closed
wzshop
Posts
2
Registration date
Tuesday June 30, 2015
Status
Member
Last seen
June 30, 2015
-
Jun 30, 2015 at 03:47 AM
wzshop Posts 2 Registration date Tuesday June 30, 2015 Status Member Last seen June 30, 2015 - Jun 30, 2015 at 07:25 AM
wzshop Posts 2 Registration date Tuesday June 30, 2015 Status Member Last seen June 30, 2015 - Jun 30, 2015 at 07:25 AM
Related:
- Copy cell from another sheet where cell is value...?
- If cell contains date then return value ✓ - Office Software Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Run macro when cell value changes - Guide
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- If cell contains text then return value in another cell ✓ - Excel Forum
1 response
awakened00
Posts
1
Registration date
Tuesday June 30, 2015
Status
Member
Last seen
June 30, 2015
2
Jun 30, 2015 at 07:21 AM
Jun 30, 2015 at 07:21 AM
Sheet1
A B
1 name age
2 michael =VLOOKUP(A2,Sheet2!$A$2:$B$6,2)
3 joseph =VLOOKUP(A3,Sheet2!$A$2:$B$6,2)
4 william =VLOOKUP(A4,Sheet2!$A$2:$B$6,2)
5 peter =VLOOKUP(A5,Sheet2!$A$2:$B$6,2)
6 john =VLOOKUP(A6,Sheet2!$A$2:$B$6,2)
Sheet2
A B
1 name age
2 john 33
3 joseph 34
4 michael 35
5 peter 36
6 william 37
A B
1 name age
2 michael =VLOOKUP(A2,Sheet2!$A$2:$B$6,2)
3 joseph =VLOOKUP(A3,Sheet2!$A$2:$B$6,2)
4 william =VLOOKUP(A4,Sheet2!$A$2:$B$6,2)
5 peter =VLOOKUP(A5,Sheet2!$A$2:$B$6,2)
6 john =VLOOKUP(A6,Sheet2!$A$2:$B$6,2)
Sheet2
A B
1 name age
2 john 33
3 joseph 34
4 michael 35
5 peter 36
6 william 37
Jun 30, 2015 at 07:25 AM