如何循环特定的列并检索特定的行- Excel

I learned how to retrieve specific values by pointing at specific columns. But now I want to learn how to loop(loop through an array) through the specific column, if matched a specific variable(from array), it will retrieve specific columns and print it out.I learned how to retrieve specific values by po