Hello,

First of all I'm new here, Ive been lurking around the forums for a while now and it has helped tremendously for the past few months, so thank you everyone.

Now that I have come up with a question of my own, I decided to register and ask away.



I have workbook "Review" and workbook "Report". In the review workbook, I am referencing many individual report workbooks for values and texts etc and constructing a table.


In Report workbooks,
A1 has text
B1 has file name for the photo hyperlink
C1 Has following formula


=HYPERLINK(MID(CELL("FILENAME");1;FIND("[";CELL("FILENAME"))-1)&"\"&N21&".JPG";" PHOTO ")

This way, C3 is hyperlinking to a file in the workbooks folder, using value in B2 as filename and adding "*.jpg" to the end (with the friendly handle "Photo")



My goal is to
In Review workbook;

B2 is Referencing to A1 in report workbook.

Clicking on B2 brings up the picture hyperlinked in A3 in report workbook.

Any help would be appreciated, thank you!