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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies