Hi Paullaup,
Here is my way of doing this (and I use it a lot).
Just to mention: I don't like LOOKUP, VLOOKUP and HLOOKUP. I prefer combining INDEX with MATCH. I had a lot of trouble with LOOKUP (wrong results), in the MATCH command you can define better what happens if you donot find the...
I have seen a nice demo of Tipos 4.0. This software was develloped by Cimware (www.cimware.de site available in english) and works with Doka, Hünnebeck (=Safway), Meva, Alsina and some other systems.
Michael