NORRILLOUS
New Member
- Joined
- Apr 10, 2014
- Messages
- 36
- Office Version
- 365
- Platform
- Windows
Sheet 1
Sheet 2
For my example, I would like to use the data above in sheet 1 to return values (Columns B,C) to sheet 2 (Column B) if value is found in Column A
A | B | C |
Machine | Order Number | ID Number |
3 | 1hbkb1 | 252we |
2 | qfw1 | 262er |
1 | wf3df | 2er7e |
1 | wgfwsg | 2e7e7 |
2 | wdgw | 27e2e748 |
3 | cedvh | 4848859 |
Sheet 2
A | B |
Machine | O,ID Number |
1 | wf3df,2er7e,wgfwsg,2e7e7 |
For my example, I would like to use the data above in sheet 1 to return values (Columns B,C) to sheet 2 (Column B) if value is found in Column A