Locate a set value and copy the value in the cell that's below it

[twmills]

Yeah, I do get a compatibility warning when going into the query editor. The attached error message is what I'm get, in the Added Index step I think?

wow, thanks so much. That seems to work!

Now what should I change if there's 5000 lines of shareholders, rather than just 500...like in the example you put together for me?

Much appreciated!!