kbsudhir
02-11-2009, 02:26 PM
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.
:help :dunno
Regards
Sudhir
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.
:help :dunno
Regards
Sudhir