PDA

View Full Version : Values as per the combination



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

mdmackillop
02-11-2009, 02:58 PM
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?