I trying to build a formula that retrieve result from two worksheets, on sheet 1 column U i have names,
i need to retrieve on column V of sheet 1 what country they are from,
on sheet 2 column E are the names to match with sheet 1 column U and sheet 2 column F are the country where they from,
then at sheet 3 on column C are the names to match with sheet 1 column U and on column D sheet 3 the country they are from.
On sheet 2 and 3 are duplicate names...

Thanks in advance for any help, hope this is possible...