Getting data from sheet 2 and putting data to sheet 2

[jackf-nc]

Sheet 2 contains:
A: names
B: dates of last sale
C: Commissions


What I am trying to do is display last 3 sales based on date - Sheet 1 C1 For example Sheet1!C1=03/23/16 I want to display name and commissions from sheet2 on sheet 1 in cells a2:a4 If there is only 1 person - then a3:a4 = "no other" - all based on date from sheet1 c1


Second Part:

Would it require some macro / vba to record new row in sheet2 based on another date from sheet1 - I39

Sheets works fine - just trying to eliminate so much cutting and pasting. Have posted an example

[JohnTopley]

in A2 (unmerge cells in A)

=IFERROR(INDEX(Sheet2!$A$2:$A$11,SMALL(IF(Sheet2!$B$2:$B$11=$C$1,ROW($A$2:$A$11)-ROW($A$2)+1,""),ROWS($A$2:A2))),"No other Person")

in C2

=IFERROR(INDEX(Sheet2!$C$2:$C$11,SMALL(IF(Sheet2!$B$2:$B$11=$C$1,ROW($A$2:$A$11)-ROW($A$2)+1,""),ROWS($A$2:A2))),0)

enter BOTH with Ctrl+Shift+Enter

[jackf-nc]

TY JohnTopley,

Worked beautifully!

How would you recommend adding data from sheet 1 to sheet 2. For example I would like either macro / or vba to add another row to sheet2 if there were sales, for the day. Sorta like a end of day type thing.

Sheet1 has names in J
Sheet1 has commissions in t
Sheet1 has date in k41

I need it placed in sheet2 like the example I uploaded earlier.

Thank you again, my friend! You have been a super help!
Jack

[JohnTopley]

Confused as none of the columns mentioned are used/shown in "example4.xlsx".

Sorry but post another file (referable a copy of the actual file you use rather than a mock-up) showing exactly what you require.