Could anyone give me the formula to look up a range L10:L50, which is pulling data from another list. If there is a duplicate name in the list to show that name as the result (there will only ever be a maximum of two names duplicated)