excel problem

Hey all, i have some text(name) in column A and Some text(names) in column B and numeric values against them in column C on sheet1. On sheet 2, I want some calculations, as if I write the two random name from each column A and B then It should find the matches and sum their numeric values.Please help me