Call dates for each customer from sheet2 into sheet1

[Zeroable]

So I run a lawn-mowing company and i'm looking for a way to enter data ONCE to fill out a season's mowed dates for each customer.
EDIT: Sheet1 into Sheet2* title is incorrect.


Ideally i'd fill out Sheet1 with a Date, and a list of the customers that were done that day, and Sheet2 would collect the dates for each customer throughout the season. Might need a sheet3/4?

I've created a conceptualization (with no formulas yet) attached.


sheet2 search sheet1's entire table for value (customer name).
if (customer name) found, return header value (date) that (customer name) was found in
repeat search in next column for next (date)

end with list of (customer name)s with seasons worth of (date)s.

[63falcondude]

Assuming that you want to pull all of the names for each date from Sheet2 into Sheet1, in B2 of Sheet1, try:

=IFERROR(INDEX(Table2[Company Name],SMALL(IF(Table2[[Column1]:[14]]=B$1+0,ROW(Table2[[Column1]:[14]])-(ROW(Sheet2!$B$2)-1)),ROWS($A$1:$A1))),"") Ctrl Shift Enter

Drag it over and down as far as needed.

Edit: I think that I misunderstood. The title confused me. After re-reading everything, I believe that you are looking to pull data from Sheet1 to Sheet2.
Working on it.

[Zeroable]

your edit is correct. would like to pull from sheet1 (date with list of names), into sheet2 (list of names with dates). sorry for the confusion, didn't notice the mistake i made in the title.

[63falcondude]

In B2 of Sheet2, try:

=IF($A2="","",IFERROR(INDEX(Table1[#Headers],SMALL(IF($A2=Table1,COLUMN(Table1)-(COLUMN($B$2)-1)),COLUMNS($A$1:A$1))),"")) Ctrl Shift Enter

Drag this formula across and down as far as needed.

Note that the spelling must be the same across both sheets for this to work.

[Zeroable]

In B2 of Sheet2, try:

=IF($A2="","",IFERROR(INDEX(Table1[#Headers],SMALL(IF($A2=Table1,COLUMN(Table1)-(COLUMN($B$2)-1)),COLUMNS($A$1:A$1))),"")) Ctrl Shift Enter

Drag this formula across and down as far as needed.

Note that the spelling must be the same across both sheets for this to work.

it's returning everything or nothing. CTRL SHIFT ENTER didn't seem to do anything. ?
trying to understand it by reading the formula.
table1 = sheet1?

[63falcondude]

If you open the workbook that you shared in post #1 and follow the steps in post #4, you will get what you are looking for.

I have attached the workbook with the formula entered for you to refer to.

Note that the misspelled names will not be pulled over.

[Zeroable]

Thank you!

[63falcondude]

You're welcome.

If that solved your question, please mark this thread as SOLVED.