Formula or VBA that will search for a list of numbers and return the row entire string

Hi all.
I am looking for a Formula or VBA that will return entire test strings based on a list of numbers. for example I have a spread sheet as follows and I would like to cut and paste a list of employee id numbers into a sheet and have the macro or formula return the entire row of information next to that number. Name, address etc.

I don't want to have to enter each one individually as there is over 2000 rows of addresses etc. I have attached a sheet that will nearly do it but you have to enter a one value at a time.

Capture.PNG

Hi Pepe,
No not really as I can still only enter 1 value to search for at a time. see attached file as a basic example of what I am trying to achive. It may be as simple as a formula rather than a VBA that will allow me to paste the list of numbers into the sheet and have it spit out the corresponding text strings.

Does the attached file using formulae do what you want?

Hope this helps.

Pete

cant open it pete

yep works.

did not realise you could give the group of cells a name. cheers for that

I didn't give them a name, so I don't know who you are responding to.

Pete