How can look up an image in one workbook but different worksheets? VLOOKUP or VBA?

There are three worksheets in one workbook; Home | Display | HouseTypes

Home- this has a Data Validated cell that allows the user to select a house type from the drop down list.
Display - this is the area where the user should be able to see the image of the selection they have made in "Home".
HousetYPES- this is where a table containing the house type names and their respective images are stored, the cells where the pictures are in are already named based on the left column house type names.

[PROBLEM] - I would like to be able to select a house type in the Home tab and then based on the selection I have made the image associated with that house type appears in the Display area. I have tried to follow most instructions on the internet in order to try and come up with a formula that isnt VBA. I tried using the the INDIRECT FORMULA :

=INDIRECT(VLOOKUP(D!$G$3,HouseTypes!$A$2:$B$10,2,0)) ----- sadly this isnt working or rather returning an image and when it does return something it is usually just a zero.

Please anyone helpit seems there is something I am missing or doing wrong and i guess my excel knowledge in vba is not that great.

Hello
You can use formulas to lookup images, see the attached example. I've created three named ranges: House_Type; Images and Image. The latter is based on the formula shown and works with the data validation selection. Copy one of the image cells ( the cell not the image) and 'Paste Special >image link' to the place required, then while selected, in the formula bar type =Image (or whatever name assigned) and hit enter. That should link those cells with the image to the data validation selection.

The only drawback with this technique is that the sizing and arranging of the images needs to be experimented with in order for them to display consistently. But with a bit of work it can be done, much depends on the quality of the image whether it scales up well or not.

Hope it helps.
DBY