Clay Icon

Tips for Matching Prospects with VC Partners in Excel

·
·

Hi everyone! I am trying to take a list of prospects and figure out which of them have taken investment from VC partners who we’ve established partnerships with. I have two table in a single workbook: one for prospects and one for our VC partners. I’ve created a column in the Prospects table called ‘Investors’ which is just a list of the VCs who have invested in the company across all funding rounds. Does anyone have ideas on how I can create another column that runs the ‘Investors’ column up against our VC partners list & pulls out investors from that list?