Hey everyone,
I know there are tons of posts out there on this, but I just can't seem to wrap my head around it at all. I'm not able to post an attachment of a sample workbook so I'll explain my dilemma.
I have one workbook with two spreadsheets: Partners and Projects. In the Partner tab, I have listed Partner names in one column, and left the Project List column empty. In the Projects tab, I have listed all the different projects and in another column, which partners these projects have been assigned to. I need to be to lookup all project names assigned to each partner in the second spreadsheet and enter them in the first spreadsheet under "Project List" but in one cell only separated by columns. Can someone help me develop a formula for this and an explanation of each step? Thank you so much in advance, internet!!!
I know there are tons of posts out there on this, but I just can't seem to wrap my head around it at all. I'm not able to post an attachment of a sample workbook so I'll explain my dilemma.
I have one workbook with two spreadsheets: Partners and Projects. In the Partner tab, I have listed Partner names in one column, and left the Project List column empty. In the Projects tab, I have listed all the different projects and in another column, which partners these projects have been assigned to. I need to be to lookup all project names assigned to each partner in the second spreadsheet and enter them in the first spreadsheet under "Project List" but in one cell only separated by columns. Can someone help me develop a formula for this and an explanation of each step? Thank you so much in advance, internet!!!