Hello. This is my first time posting to this forum, though I use this resource frequently! Thank you for all your hard work!
I have attached a very simple example of the document in question to illustrate my needs. This document will be used to project staffing requirements for company projects. Sheet 1 is the input tab. A staffer will input all the people that will work on the project and the employee’s internal job code and client job code will return with the use of VLOOKUPs.
Sheet 2 summarizes all of this information into a template by unique combinations of different job codes. The unfortunate part of our process is that our company’s internal job code does not match that of our client's for the same work. Ex. Our job code 1234 can be either an Analyst or an Accountant while an Analyst can be codes 1234, 1235, or 1236 internally.
What I need is a formula for Sheet 2, Column A that will look at the unique combination of job codes between our company and the client and bring back the names of all the employees into one cell.
I got as far as utilizing a lookup_concat formula (an example is in Sheet2, Cell A2). However, this formula works by referencing only one cell; I need it to reference two. Is there a modification that can be done?
Thank you so much for your help!
Bookmarks