Hi Gerry,
thank you for your reply. Point about being more specific taken.
The list is on a named range called CustomerID, consisting of around 3000 records. A separate worksheet consists of multiple rows, each row containing a field CustomerID. Now, to assist the person entering the data, the...