Hi I need help

New Contributor

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 

 

Thomas_Brandon_0-1667478208204.png

 

1 Reply

@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&"/")