Performance: Find value in a ListColumn vs. Find key in a User-Defined Collection in VBA

I have a User-Defined VBA function that needs to repeateadly find the Row index position of a specific value in a ListColumn.

I've tried using the Range/Find function to return the matching cell index row within the DataBodyRange of the ListColumn, and also created a Custom Collection, which I filled with the ListColumn cell values as Keys, adding each item in same order as the ListRow indexes.

Right now, the workbook only has limited rows, and either method seems to perform quickly, but I'm wondering if anyone knows if there's a speed penalty for using Range/Find vs. just referencing a Collection item by its key for massively-repeated calls and over several thousands of rows.

Is there yet a faster way to do this?

Thank You!

Calls to the Worksheet from code are slow and should be done sparingly. So a collection would seem a better option as operations would be done within memory, I generally stick sheet data into arrays, work on that then write it back even for small amounts