Generate file hyperlink based on concatenated Cells.

Sorry if I worded the title wrong. Let me explain

My spread sheet is set up like this

_____A_______________B_______________C_________________D
1 File Path________Vendor Name_____Invoice Date_______Invoice Number
2 =B&C____________MASSY__________1/31/2022__________1234
3 =B&C__________PIZZA HUT________1/29/2022___________6549

My excel sheet is in the same folder as pdfs of each invoice and each invoice has the name format "B&C" like MASSY1234.pdf and PIZZA HUT6549.pdf.

Is it possible to have A2 return the a hyperlinked path for the file so the user can click it and it opens up?

I know that you can go to manually do it with Insert-->Link and browse for the location but can this be automated?

Just add ELSE and then what you want it to do

Please Login or Register  to view this content.