OK I have a table that looks something like this:
<tbody>
</tbody>
On another sheet I have a table that has the UPN and columns F to J. If the UPN matches and the type matches the column headings then I want the points to go into the relevant column.
Really hope this makes sense, any thoughts on how I can do this? VBA or formula would be really helpful.
Thanks
A | B | C | D | E | F | G | H | I | J |
Surname | Forename | UPN | Type | Points | Talking when the teachers talking | Equipment | Homework | Disruption to Learning | Attitude to Learning |
Aashir | Muhammad | DXxxx | Talking when the teachers talking | 1 | |||||
DXxxx | Equpment | 1 | |||||||
Abdillahi | Yaqub | EXxxx | Homework | 1 | |||||
EXxxx | Disruption to learning | 2 |
<tbody>
</tbody>
On another sheet I have a table that has the UPN and columns F to J. If the UPN matches and the type matches the column headings then I want the points to go into the relevant column.
Really hope this makes sense, any thoughts on how I can do this? VBA or formula would be really helpful.
Thanks
Last edited: