I have column "E" that has Preventive Maintenance description e.g "Air Handler -Annual", but also may have PM description with a Job plan numbers at the end e.g. "VALVE, DELUGE-QUARTERLY0000001469". I currently use a hyperlink (thanks to help on this forum) that takes numbers at the end of description and links; problem is some have job plan numbers and others don't.


I'm looking for a formula that will...
If data in Cell E3 has numbers at end of description (or anywhere) do this "=HYPERLINK(CONCATENATE("\\company_shared_drive\J_PLANS_CUT\",RIGHT($E$1:$E$64000,10),".pdf"))", if not than say "No Link".


Cell E3: VALVE, DELUGE-QUARTERLY0000001469
Cell E4: Air Handler -Annual
Current formula being used to hyperlink works great, just want to add more =HYPERLINK(CONCATENATE("\\company_shared_drive\J_PLANS_CUT\",RIGHT($E$1:$E$64000,10),".pdf")

Thanks in advance!!