VBA can also be used, which is more powerful.
It depends on the specific needs.
Ordinary application VLOOKUP function, according to the conditions of the query. If the column is offset, you can use the column function to realize automatic offset. You can use absolute relative mixed references as references.