How to create conditionally dependent cells in Calc?

Question

openoffice

There is a table consisting of two columns "name" and "quantity". How to make another table (maybe from another file) find a certain "name" (or better a keyword) in the first table and take the corresponding "quantity"?

Answer 1

Don't go into this rotten swamp. Leave Excel Excel.
But hold on, similar functions should be in calc
https://www.planetaexcel.ru/techniques/2/106/