Vlook up to display image

[Mattyevs1000]

Hi.

I have a worksheet that has a
1. quote page
2. Specification.
3. Data validation text
4. Parts.


The full written specification uses multiple v look ups to get information from the relevant sheets to produce a specification. The specification has up to 200 parts available and where the row is populated with a part selected from the quote page, column A shows 1. If it is blank, it shows 0. I then run a filter to hide all cells containing 0. Each specification item takes up 5 x rows.

Question. I would like to add an image against each chosen part in the specification.

Many thanks in advance.

[Pete_UK]

Take a look at John McGimpsey's site, here:

http://www.mcgimpsey.com/excel/lookuppics.html

Hope this helps.

Pete

[Mattyevs1000]

Thank you Pete!

[Pete_UK]

Glad to help - thanks for the rep.

Pete