My database programming experience to this point has been with Access. I
have been asked to handle a project which I would normally tackle using
Access. However, existing data is already in Excel, and the person
requesting the work is keen to retain Excel. Can someone tell me:
Is it possible to create related tables in Excel so that one table can be
used as a lookup for another? Also, is there any possibility of adding
something like a combo box or other drop-down list on an Excel sheet?

Leonard Priestley