Custom views filter plugin: cachetags invalidation does not effect option list

I described a custom views filter plugin extending InOperator. The aim is to offer a select list where the user can choose from a list of fractions of a legislature. Legislature and fractions are custom entity types, the fraction entity references to the legislature just for background explanation. Views offers automatically an exposed filter but…

Details

How to retrieve the VALUES from sheet1 to sheet2 according to the NAMES?

On Google Sheets, how to retrieve the VALUES from sheet1 to sheet2 according to the NAMES? Generically speaking, would be something like: GET VALUE FROM sheet1 WHERE NAME = sheet2!NAME I tried some uses of MATCH and VLOOKUP without success. Thank you. Edit: Here an open sheet to test: https://docs.google.com/spreadsheets/d/1YMUfpz-m2RmEhR1Zi_qUpdt9YtswJFOnisiZhUYZAAU/edit?usp=sharing

Details