How to make a randomness formula?

Question

Google Sheets

I need to use VLOOKUP in line F to find post ID 1, but this formula always selects the very first option for post ID 1 -1212. And I need the formula to select, for example, each of the posts from the first plate, and that post ID 1 is not duplicated.
That is, if it is duplicated, then the formula does not work. Or random somehow?
Can this be done somehow?

Answer 1

In Google Sheets, use the FILTER function .

Answer 2

1)
This formula will return all the data for the filter:
=FILTER(ДАННЫЕ;УСЛОВИЕ_ФИЛЬТРАЦИИ)
2)
This is how you can take a random one from the set:

=ИНДЕКС(ДАННЫЕп1;ОКРУГЛВВЕРХ(СЛЧИС()*ЧСТРОК(ДАННЫЕп1)))

Demo table