Hi All,
I have set of names in pairs of two of thirty people with different combinations. ex Tom in A1 & Jerry in A2 then I should get "Maths" in B2.
Now, If I have Tom & harry in "A3" & A4" respectively then I should get "science" in B4". lastly is is "Jerry" in A5 & "Harry" in A6 i need the value "Arts" in B6.
Please guide.
Regards
Sudhir