Lookup function that produces a image

I was hoping someone could help me with this.

I have a table with a column or unique values and column of URL's that are images.

I would like to know if were possible to be able to do a vlookup that could produce the image with in the workbook.

Thanks,
Brian

Originally Posted by MarvinP

Hir Brian,
I'd need a sample to understand what you are trying to accomplish.

VLookup returns the value in a cell in a range that matches the first argument in the VLookup function.

I'm wondering how returning a value in a range would open a URL or an image? Not that it can't be done somehow but just need an example to try.

Thanks for looking Marvin,

I have attached an example.

I'm not sure how I would be able to produce the image?

Thanks for the help!

Brian

Originally Posted by MarvinP

Hi Brian,

Try in F3 this formula.
=HYPERLINK(VLOOKUP(E3,A1:B2,2,FALSE),E3)
This finds the hyperlinked string and returns it and then makes it a hyperlink with the friendly name you searched for.

See the example file. Look in F3 to see if this works for you.

Thanks, that works.

I was hoping there would be a way to keep it all in the sheet.

Like have a box where the image would populate. Do you think this is possible?

Thanks,
Brian

Originally Posted by MarvinP

I tried what I think you are leading to a few months ago. I wanted to keep a web sales inventory in a workbook. I found keeping each .jpg in the workbook made the file so big, so fast it wasn't worth it. I found clicking on the URL was just as fast and more efficient.

Hope this helps.

Thanks,

This will definitely work.
I was just hoping there would be a way to have it within the worksheet.

I really appreciated your input.

Thanks again for you help

Brian