Genii Weblog

Yesterday, I wrote about using the OpenSesame @DbColumn call. Today (now that it is working), I though I'd share the @DbLookup logic, which is a bit more complex, but very powerful. Below are a couple of simple examples. The first returns the values in cells from F4 to F50 for which the corresponding value in column E is equal to 4. Taking a look at the spreadsheet, you will see that this matches F4 ("Red"), F7 ("Silver"), etc.

All in all, the choices for comparison include starts with, ends with, contains substring, equals, does not equal, as well as less than, greater than, less than or equal to and greater than or equal to. For example, you could use: