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.
CAclubindia
