The formula I am using is an array formula and takes way too much memory to use effectively. {=SMALL(IF('List'!$D$3:$D$200000="Yes",ROW('List'!$D$3:$D$200000)),ROW(1:1))}, it looks for all values of "Yes" and returns the row number. Unfortunately there are around 80,000 yes values and I need the positions of all of them. Is there code that can make this easier (and less frustrating) for me?

TL;DR: I need a code that will look through 200,000 rows, look for a value, and return the row number of all of those certain values.