Which only takes O times, but there are a lot of functions and this will be called quite a bit.<BR><BR>I'd imagine it would be better with a hash-table, but then I need to worry about collisions.

Google Gemini can help you create content and calculations for Google Sheets. Gemini can serve as a smart list generator that produces content in a table for you to export to a Google Sheet, or ...

In older versions of Excel, people have used functions such as VLOOKUP, INDEX, and MATCH to create relationships between tables, but in newer versions of Excel, there is a Relationship command ...