I imagine this would be a vlookup with wildcards in Excel, but I’m not a master of that either.


But maybe it’s a ‘find’ or something else here?

I can’t think of a way to do this. Keep in mind that while Airtable’s grid view looks a lot like a spreadsheet, it’s structurally very different because it’s a database. Records (rows) have no knowledge of each other, at least not natively. There are some table tricks you can use to do certain types of cross-row comparisons, but what you’re looking to accomplish is actually fairly complex. You’re trying to match a character sequence of unknown length between an unknown number of records. If the character sequence length were fixed—i.e. matching the last five characters with the first five characters—there may be certain ways to pull off a variation of that idea, but even there it would be very limited. Opening it up to try to find matches of any length is way more complex.

I’m all for weird, but even with the tricks that I know can kinda-sorta work, they will only just barely work in the right circumstances. Sorry.

Thanks for taking the time to think about my dilemma.

I may just have to approach it like a database instead. Or do it manually. I am beginning to realize how very complex this thing could get.

Wildcard searches within a field are very common in other Bases. And yes I’ll mention Alpha again! Even the free ones! It is extremely annoying to try to add, for example, an inventory item that is linked to your line items or invoice.


I really don’t want to hunt through 100 different Hallmark Card, or Socket wrenches (you name it) when I want the “Fluffy Dog” or “Hammer”.


Other systems, and even a web search, will start popping up answers with just a few letters typed in. (“fluf” or “craft”. Heck - don’t even need capitals!!!


So what’s the problem here???