In this case study, you have been asked to create an automated spreadsheet to produce the outcome that is similar to the Output worksheet. You are given 2 worksheets to work with:
computer science
Description
In this case study, you have been asked to create an automated spreadsheet to produce the outcome that is similar to the Output worksheet. You are given 2 worksheets to work with:
1) JobPosting
2) HRDirectory
From the JobPosting worksheet that contains 3 job postings, please create formula in excel such that it will lookup and match the job postings' companies against the right contacts from HR Directory.
For example, there is a job posting on SATS Ltd, so you need to match the 16 people found in SATS LTD in HR Directory into the same job posting. This is to enable our recruiters to have the right contact point when reaching out to people in SATS Ltd.
However, your formula should be smart enough to retrieve the 16 people from SATS Ltd and then automatically move on to the next job posting and populate with the right contact points for the next job posting. It should replicate the outcome found in Output spreadsheet. Your spreadsheet should automatically re-churn the output if we refresh the job postings with another companies so that its automated.
