Find Data in Tables w/o index match

[Kappy]

I just started using tables to store my data and I love that I can reference fields without explicit cell references..

Nevertheless, when I need to look up data into one table from another, I use the same old index(match).. which of course works great, but considering the field/record structure of tables, I'm curious if there isn't a simpler way to do this.. i.e., something like a WHERE statement in sql..

So far, I've found nothing.. and since I dreamt this up, its likely there isn't anything like what I'm describing..

but I thought I'd put it to the pros before I gave up looking..

Thanks