Hi I need help

[Thomas_Brandon]

i need a formula to use the job Req ID cell and input it into the weblink on the same line. i have manually inputted to the 1st line so what i need can be seen

some help would be much appreciated 

[#2]

@Thomas_Brandon 

Assuming that Job Req ID is in A2 and down: enter the following formula in D2, then fill down:

=IF(A2="","",HYPERLINK("https://careers.serco.com/job-invite/"&A2&"/")