Lookup value then autofill entire row

Hi,

I have an excel file that contains multiple sheets. I have a sheet called All_Hardware and it contains all desktops and laptops in our domain and I have a sheet called Hardware that has a list of users in our domain. I would like to lookup the users from sheet Hardware (Colum A) in the sheet All_Hardware (Also colum A) and if it exists it should copy all information from that row to the row in sheet Hardware.

If someone could help me it would save allot of time .

Thank you in advanced.

PS. If an example is need just let me know. I will create an example file.

NeedForExcel thank you for you responds. I've created an example file. As you can see in the file I have a Hardware sheet and a All_Hardware sheet. If I fill in a user name in colum A Hardware sheet it should search in colum A All_Hardware sheet if it exists. If so it should copy the information in from that row (B,C,D,E,F,G,H,I) to the Hardware sheet, like the example on row 10.

Example.xlsx

Maybe:

Please Login or Register  to view this content.

Thank you NeedForExcel and JOHN H. DAVIS. Both work perfectly . Now I just need to check which one I will be using.

Thank you again! Problem solved!

You're welcome. Glad to help out and thanks for the feedback.