Struggling with VLOOKUP for Company Executive Scoring in Europe

Hey folks, I’m struggling to do something that seems very basical. I’ve searched a list of companies in Europe and then searched their top executives. Then I created a scoring at Company level to detect if their executives are present in France, Spain, both countries, or none. This gives me a score and I would have liked to send that score back to People’s table, like a “company’s data”. It’s a basical VLOOKUP, but it does not seem to be feasible. WDYT? Thanks in advance!