Excel Exercise for School Based Interview

Hi All,

I tried to compose a thread with links to pictures etc, but because I just joined, I cannot do so before a few posts.
I am in need of some help using excel, which I have not done in over 15 years.
In the process of applying for school based roles as an exams officer and in all shortlisting and interview process, schools require candidates to do an excel based exercise. In a recent interview last week, I tried to use vlookup but was running against a clock to complete the other exercises, so instead did it manually - thankfully there were not many records.

I have a few more interviews coming up this week and next, and I want to be ready for any excel exercises. So I tried to do the one from last week using vlookup etc. but cannot get my head round it. And I am sure, there are easier ways of doing things than what I did - I wish I can post with pictures to show the exercise and what formulas I've used.

The exercise is:

"On the excel spreadsheet there is an entry sheet received from the Science department asking you to confirm the pupils have been entered for the correct exam.

As you will see, there are three possible tiers for this exam:

• Higher – Exam code – A217H.
• Intermediate – Exam code – A217I
• Foundation – Exam code – A217F

There is also a report printed from the Academy’s exam system confirming the actual entries sent to the exam board.

Please cross-check the two documents and identify whether pupils have been entered in accordance with the Science department’s wishes. Highlight in yellow any mistake or queries you might wish to discuss, and leave additional comments that explain what your queries are."

I will post soon as I am able to with pictures etc.
Thanks,
Jay

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Hi Jay,

No problem. The two forums are not linked, but we have many members who frequent many different forums. It can be very irritating to work on a problem here, just to find out somebody has answered it elsewhere.

Please read the link posted above for further clarification.

Jay, we still need that link before members will be permitted to give you suggestions

Just post the address with a couple of spaces in it.

Solution for EXACT match:
In K4:

Please Login or Register  to view this content.

Due to differential in both list', i.e: "Tabitha BAILEY" and "Bailey Tab ; I try to combine the D.O.B and either surname or first name:

Please Login or Register  to view this content.

Drag down