Excel formula help

New Contributor

Hi,  I run a National Photographic Salon every year and have for the past 3 years built up an Excel DB for the Results.  This consists of each year being put on a new page.  I am trying to get a formula together that will enable me to click on a link that will call up the image from a folder.  There are 4 categories or class codes OPMN, OPCL, NATR and CRTV.  The images are title thus (DI-OPMN (according to class)-001161-01659-001273.jpg).

In my spreadsheet i have columns titled 'class-code' and 'filename'.  They are the 2 columns i am interested in.  at the moment i am using the formula '("\NDPS UK Salon\NDPS UK Salon 2018\Judge Images\DI\OPMN\"&U183,"Open Image")  this opens the image in U183.  By dragging the formula down the spreadsheet it will auto change the relevent U column figure.  What it will not do is read the class_code in the class_code column so i have to manually change that.  Help would be appreciated.

0 Replies