Use worksheet as user interface for database

[figment]

try this

Attachment 7504

the code creats the needed vlookup functions. it relyes on the named ranges that you had already set up in the example sheet.