Advertisement
User stated she used to do it all the time with 2013 before office 365 but doesn’t remember how. There is data in one sheet with usernames, first names, last names, status. 2nd sheet has usernames and status2. They user to somehow merge data where sheet1 username and status=x and sheet2 username and status=x, then add sheet2 status at the end on sheet1.<\/p>\n
Example:<\/p>\n
Sheet1<\/p>\n
username status<\/p>\n
guy failed<\/p>\n
Sheet2<\/p>\n
username status<\/p>\n
guy blocked<\/p>\n
then sheet1 should read<\/p>\n
username status status2<\/p>\n
guy failed blocked<\/p>","upvoteCount":6,"answerCount":2,"datePublished":"2020-01-02T22:08:17.000Z","author":{"@type":"Person","name":"troymckenzie0714","url":"https://community.spiceworks.com/u/troymckenzie0714"},"acceptedAnswer":{"@type":"Answer","text":"
The VLOOKUP function should do the job.<\/p>","upvoteCount":1,"datePublished":"2020-01-03T10:04:37.000Z","url":"https://community.spiceworks.com/t/merge-data-two-worksheets/744984/2","author":{"@type":"Person","name":"anon_39553083","url":"https://community.spiceworks.com/u/anon_39553083"}},"suggestedAnswer":[{"@type":"Answer","text":"
User stated she used to do it all the time with 2013 before office 365 but doesn’t remember how. There is data in one sheet with usernames, first names, last names, status. 2nd sheet has usernames and status2. They user to somehow merge data where sheet1 username and status=x and sheet2 username and status=x, then add sheet2 status at the end on sheet1.<\/p>\n
Example:<\/p>\n
Sheet1<\/p>\n
username status<\/p>\n
guy failed<\/p>\n
Sheet2<\/p>\n
username status<\/p>\n
guy blocked<\/p>\n
then sheet1 should read<\/p>\n
username status status2<\/p>\n
guy failed blocked<\/p>","upvoteCount":6,"datePublished":"2020-01-02T22:08:17.000Z","url":"https://community.spiceworks.com/t/merge-data-two-worksheets/744984/1","author":{"@type":"Person","name":"troymckenzie0714","url":"https://community.spiceworks.com/u/troymckenzie0714"}}]}}