I posted a similar question yesterday and I can't find it.

My database worksheet on Column B lists the names of diffrerent clients. On
Column A, there are numbers assigned to the clients on Column B.

Everyday I get a report of the clients (most of the time, multiple names of
a particular client is included in the list) I copy and paste this
information on Column B on my own Worksheet (not the database worksheet).

On Column A on my worksheet, I'd like to have a formula to show the
corresponding assigned number of a client on Column B.

Please help.