Cell Hyperlink by Partial file name

[Kiloelectronvolt]

Hi All!

This is hard for me to explain, but is there a way to hyperlink a cell to a specific file only using a prefix of the filename?

All of our files start with PO 100-, PO 101-, PO 102- but then there's random employee descriptions typed after the prefix.

If the PO # is listed in B2, Can you hyper link to C:/Filepath/&B2 and have it pull the file with that prefix in it

Example:
So, if it's C:/Filepath/PO 101-Staples for office.pdf Can excel hyperlink to the file based of the "C:/Filepath/PO 101-"

 

[DRSteele]

Sure can. Just use function HYPERLINK and concatenate the contents of other cells that contain the folder path and the file names. Like this:

MrExcel posts18.xlsx
	A	B	C
5	folder location
6	D:\OneDrive\Documents\X L\
7
8	files in folder	hyperlink	hyperlink with friendly name
9	dates1.xlsx	D:\OneDrive\Documents\X L\dates1.xlsx	dates1.xlsx
10	dates2.xlsx	D:\OneDrive\Documents\X L\dates2.xlsx	dates2.xlsx
11	dates3.xlsx	D:\OneDrive\Documents\X L\dates3.xlsx	dates3.xlsx
Sheet41

Cell Formulas
Range	Formula
B9:B11	B9	=HYPERLINK($A$6&A9)
C9:C11	C9	=HYPERLINK($A$6&A9,A9)

 

[Kiloelectronvolt]

EDIT- I realize my question is confusing. sorry about that. It's about the file names being somewhat out of pattern in our file path.

PO 101-Staples for office.pdf
PO 102-Tires for truck.pdf
PO 103-Cleaning Supplies for conference room.pdf

I was wondering if you can have excel hyperlink grab the file by just the beginning prefix because the descriptions after the PO # are wild.

 

[Kiloelectronvolt]

Hi! I don't know if I'm allowed to bump this?

Thank you.