Excel formula help

Occasional Visitor

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies