Comparing data against table of values to output new data.

[iMAN2]

Hi guyz,
The title is most probably really confusing so ill just give a quick run down of what i really need. Sample data is attached.

Sheet 1 - Enter Marks
Sheet 2 - Moderation Comparison
Sheet 3 - Moderated marks (output)

Data is inputted into sheet 1. The marks for each respective subject need to be compared against the table in sheet 2. This new mark is then to be outputted in the respective columns in sheet 3.

Specific things needed: (text colour green in sample sheet for easier reference)

If a subject contains the word 'accelerant' then for that name entry a comparison shouldn't be made and the original mark should be kept as the output mark. E.g. Chemistry

If there are mutliples of a subject for 1 entry, e.g. 2 physics then it should return a pop-up error (stating for which name entry this occured). If this is not possible, then in sheet 3 for the mark it should read 'check'. An example of this is in sheet 3 for the last entry in the sample data.

If for the comparison there is no comparison mark in sheet 2 to compare the sheet 1 mark against, then the output mark in sheet 3 for that entry should read 'check'.

Crosspost at: http://www.thecodecage.com/forumz/ex...urn-value.html

Thankyou guyz for your help.