Using database by macros or any tools.

I have a database in LibreOffice Base, two columns “articul” and “price”. This database is registered in LibreOffice and I have access to this base in LibreOffice Calc.
Can I get this data from cell in LibreOffice Calc automatically?
For example: in cell I have a value “FD34GS”. Can I use macros for get price by select this value from datasource? This is possible? I can`t find any examples.

Hi @dyachenko,

I’m not quite certain what you’re looking for. Does the column “articul” serve as a unique index value for the given prices? Are you asking how to look up a price in the database given an index from the “articul” column of the database?