How to create conditionally dependent cells in Calc?

T

Tagoryanin2020-03-17 06:35:57

openoffice

Tagoryanin, 2020-03-17 06:35:57

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"?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

V

Vladimir Korotenko, 2020-03-17
@Tagoryanin

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/