Hi
I have a set of data where colum A has a lerner Name
Column B has the different units that learner is enrolled for Example
English, Maths, Physics, Biology (Max 4 units for each learner).
Column C has marks for each unit.

So one learner can have 4 Rows and 3 columns, now when i want to lookup
function, I want it to lookup for a learner Garry and find his marks in each
unit.

How can i do it? Please help, it will be much appriciated.! Thanka