VLOOUP Pictures

Friends:
I am creating a directory of our community. I have information about the families but I would like to add picture to this information so people can easily reconcile name with pictures.

In the attached spreadsheet I have three worksheets (1) MAIN DIRECTORY, (2) DIRECTORY and (3) PICTURES. I want to use a LOOKUP/INDEX or MATCH functions to get pictures from the PICTURES worksheet and paste them against the correct name in MAIN DIRECTORY.


Can anyone help me to sort this out. I tried many different ways but not successful.

Your help will be very highly appreciated.