Column A & B can contain over 500,000 values and changes over time.
What is the fastest code that will find all cells in column A with "Hello World" and put the corresponding value(s) from column B in an array without iterating through all the rows.
Hello World aaaa
Hello World bbbb
In the above example it would put aaaa and bbbb in an array because "Hello World" is in column A for them both.