How to pull data about the date of the company's report by the tag that I write in the next cell in GOOGLE SHEETS?

Question

excel

For the investment table, you need to pull up data on the nearest date of the company's report.
Google Finance does not have this feature.
Manually pulling up the data with a screener is also a long time.

The task is precisely when I enter a company ticker to pull up the report date specifically for this ticker.

Answer 1

VLOOKUP(запрос; диапазон; номер_столбца; [отсортировано])