How to select a value based on data from multiple rows?

Question

SQL

Good evening.
I have a table with the following structure:

ID  NAME    VALUE
1    foo      1      +
1    bar      2      +
2    foo      3
2    bar      1

I need to select ID value by VALUE column. In this case, you need to take into account VALUE for rows with the value of the NAME column, both foo and bar (marked with plus signs above). At the same time, if I write something like
WHERE VALUE = 1 AND VALUE = 2
nothing, of course, it won’t work, because. verification occurs within a single line. If I replace AND with OR, then in the resulting set I will also get ID 2, because the VALUE column contains non-unique values. I tried a lot of things besides this, but none of the options with subqueries and joins worked - I just can’t figure out how to take into account the previous ones with each subsequent check.
How to be in this situation?
Thanks in advance.