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
Bookmarks