Reg. Excel Formula

Please tell me which formula could be used to get the text value from another sheet if other text is similar with a criteria or range.

Suppose I have a sheet containing some name anf group name. now i pasted name in another sheet  and want to insert a formula in that sheet in such a way so that gropu name matching with the name will display itself. I tried to use if(lookup) formula, but its not working.

Guide me its urgent.