VBA code to open .pdf's saved in different folder locations

Hi,

Looking for some help creating a VBA code or IF function that will open a .pdf based on values within 2 different cells.

For instance Column F can have a range of Chapter numbers e.g 32, 52, 55 etc. which relate to specific folder names saved on a drive (for this example: my desktop)

I.E

C:\Users\(USERNAME)\Desktop\32
C:\Users\(USERNAME)\Desktop\52
C:\Users\(USERNAME)\Desktop\55

Column M has .pdf file names such as

Chapter32_drawing1.pdf
Chapter32_drawing2.pdf

Chapter52_drawing1.pdf
Chapter52_drawing2.pdf

Essentially I want to create a hyperlink in Column N, that will find a specific (Chapter) folder based on the value of Column F, and return the file name based on information in column M.

Cell F2 = 32 + Cell M2 = Folder 32 + Chapter32_drawing1.pdf
Cell F3 = 52 + Cell M3 = Folder 52 + Chapter52_drawing1.pdf

Then the N Column hyperlink automatically opens the .pdf

N2 = C:\Users\(USERNAME)\Desktop\32\Chapter32_drawing1.pdf

N3 = C:\Users\(USERNAME)\Desktop\52\Chapter52_drawing1.pdf

The Chapter folders need to exist for the sake of organising the drawings inside them, I know this would be much simpler if all the drawings were in one Folder.

Any help would be amazing!

Thank you so much that worked perfectly!

Thank you for the Tips, as you are probably aware this is my first post so I wasn't quite sure of the forum etiquette. For now there is no reason why I cant use the hyperlink formula. Once again thank you