Lookup value then autofill entire row

[miksel]

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]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[miksel]

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

[NeedForExcel]

Here!

Put this in Cell B2 of Hardware Sheet

=IFERROR(VLOOKUP($A2,All_Hardware!$A$1:$I$1129,MATCH(B$1,All_Hardware!$A$1:$I$1,0),0),"")

Drag down and across as required.

Also I suggest formatting you Source Data Table as an Excel Table (Ctrl+T). This will take care of any added rows..

Please see the file attached.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[miksel]

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!

[NeedForExcel]

Glad we could help..

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

You can also thank those who have helped you by clicking on the Add Reputation button if they helped.

Thanks.

[JOHN H. DAVIS]

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