How to use "if" function to check conditions of different ranges?

Question

Google Sheets

Hello everybody. There is a cell. There is an immutable range and there is a range that is always changing. So here's how to make data appear in the cell if there is information in both ranges?

Answer 1

If the information is in the first range and if the information is in the second range, then display the data in the target cell, whatever is meant by the word "is" (you should come up with a formula) and whatever the data is (you should come up with an expression for calculations).
That is, the logic is as follows:
=ЕСЛИ(И(..... ; .....); ..... ; "")
PS Although this does not apply directly to the question, but just in case, I will add. You can check the availability of information, for example, like this:
=СЧЁТЕСЛИ(A1:A99;"Москва")>0
It will be true if and only if "Moscow" is in the specified range.