Dynamic Lookups

[Tim Fischer]

Ok, in my quest for a completely drop-in system here, I've come across
another stumbling block.

I need to create a lookup statement on the fly.  I know how to make my
lookup file dynamic:

If:
Then: aa(25,*)="FileName"
If:
Then: lookup test = (aa) .......

Then, setting the key to a dummy variable is simple, but is it possible to
actually use the value of a field (or dummy variable) as the index?

For example:

If:
Then: aa(25,*)="FileName" ; ab(10,*)="Key" ; ac(1,*)="D"
If:
Then: lookup test = (aa) k=ab i=(ac) -nx

Or, do I have to test to see what my index field is and run the lookup after
I find out?

For example:

If:
Then: aa(25,*)="FileName" ; ab(10,*)="Key" ; ac(1,*)="D"
If: ac="A"
Then: lookup test = (aa) k=ab i=A -nx
If: ac="B"
Then: lookup test = (aa) k=ab i=B -nx
Etc...

Thanks again everyone!!!

Tim Fischer