Create a Job Recruitment Hyperlink from an Excel ID
Question details
Create a clickable job recruitment link automatically from the Job Req ID in the same spreadsheet row.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet contains Job Req IDs, and each populated row needs a link to its corresponding job posting.
- Observed behavior
- Each link should display the Job Req ID as clickable text, while rows without an ID should appear blank.
Confirm that the Job Req IDs start in cell A2 and that column D is available for the links. If your IDs are in a different column, adjust the cell reference in the formula.
Use a HYPERLINK Formula to Build Job Links
Create a link for each Job Req ID and leave the result blank when the ID cell is empty.
Select cell D2 and enter =IF(A2="","",HYPERLINK("https://careers.serco.com/job-invite/"&A2&"/",A2)).
Select D2 and drag its fill handle down column D for all rows containing or expected to contain Job Req IDs.
Click a populated link in column D and confirm that it opens the intended job posting in your browser.

Create Job Recruitment Links in WPS Spreadsheet
Use the same IF and HYPERLINK formula in WPS Spreadsheet to turn Job Req IDs into clickable links and fill the formula down your worksheet.
- 1. Open your workbook: Open the Excel workbook in WPS Spreadsheet and locate the column containing Job Req IDs.
- 2. Enter the link formula: If the first ID is in A2, select D2 and enter =IF(A2="","",HYPERLINK("https://careers.serco.com/job-invite/"&A2&"/",A2)).
- 3. Fill down: Select D2 and drag the fill handle down to apply the formula to the remaining rows.
- 4. Check and save: Click a generated link to test it, then use File > Save to save the workbook.

Frequently Asked Questions
How do I change the formula if my IDs are in another column?
Replace both A2 references with the cell containing the first ID. For example, use B2 if the first Job Req ID is in column B, then fill the formula down.
Why does the link cell appear blank?
The IF function returns a blank result when the ID cell is empty. Enter a Job Req ID in the referenced cell to generate its link.
Can I display different text instead of the Job Req ID?
Yes. Replace the final A2 in the HYPERLINK function with text such as "View job". Keep the earlier A2 reference in the URL so the link still uses the ID.
What if Excel does not accept the formula?
Check that the formula begins with an equals sign and that the quotation marks are straight. Depending on your regional settings, you may also need to replace the argument-separating commas with semicolons.




