Transfer multiple columns to new workbook. Please help

[Thepod]

Hello,

I am still learning functions in Excel and sometimes it is very overwhelming for me. I am trying to transfer data from one sheet to another sheet by searching the customer name.
I know VLOOKUP but it will only give me one result. Does Index Match work for something like this? I tried but it would only transfer the date.

I have 2 worksheets both with the same information. The columns have a customer name, a date, and employee name and the total number of hours worked. Once this is filled out, I am trying to transfer all the column information to the second worksheet based on the customer name.

Is there a formula that will search the table on the master for the customer name and then transfer all the data from that row into the new worksheet?

Thank you!

[daffodil11]

I'd recommend an INDEX(..SMALL( to filter on the desired information.

For example, A4 on Macy's:

=IFERROR(INDEX('Daily Labor Log'!A$4:A$33,SMALL(IF('Daily Labor Log'!$A$4:$A$33="Macy's",ROW('Daily Labor Log'!$A$4:$A$33)-3),ROW(A1))),"")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

This formula would be copied down and over as needed.

You may wish to encapsulate other formula depend upon these columns in =IFERROR(reference, "")

[daffodil11]

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