Forum Discussion
Hi I need help
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...
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&"/")