Values as per the combination

[kbsudhir]

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

[mdmackillop]

You'll need to provide more information. There is no way to assist with that. Can you post a sample workbook showing how your source data is stored?