Little help step by step, Bringing in pictures from one spreadsheet to another via a cell refference.

[Head Laker]

I have attempted to create a picture directory. I have a master sheet that has all the data, (names, addresses, phone and emails info).
i have another spreadsheet that i would like to save the pictures of the residence too. Column A for about 500 spots.
Based on their Lot Number, (When i enter their lot number), it would like to pull their picture into a cell beside their info.
But i need to know how to get the picture all the same size and so that they don't get distorted when i pull them in.
Does that make sence? all without macros or vba

 

[Fluff]

Duplicate to: Picture directory

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.