vlookup help, can this be done? (cells in J&K filled with info from G&I if data in C is a repeat)

[Mike Luce]

ok, I am sure I was doing something stupidly simple wrong.


but I need to get results based on an entered data point.


example in the spreadsheet:
enter data in C16
search column C for the first repeat of data starting at current entry(C16) if found(C9)
pulls data from column G(G9) and enters it in column J of current entry (J16)
then pull data from column I (I9) and enters it in column K of current entry (K16)

 

[Mike Luce]

didn't mean to submit this yet still can find were to attach the spreads sheet or screen grab

 

[kweaver]

This is a little confusing. You are trying to find the first appearance of the contents of C16 by looking in column C -- starting WHERE? Starting in C9 and looking DOWN until you get to C16 where the searched-for data is??

 

[kweaver]

Maybe you want this? J16: =INDEX(G1:G15,MATCH(C16,C1:C15,0),1)
And, K16: =INDEX(I1:I15,MATCH(C16,C1:C15,0),1)

 

[Mike Luce]

This is a little confusing. You are trying to find the first appearance of the contents of C16 by looking in column C -- starting WHERE? Starting in C9 and looking DOWN until you get to C16 where the searched-for data is??

i still have not figured out out to add a screen grab or sample file to the post so i have recreated the data Directly in the post.

This sheet will be a year long record and used to track repeat offenders.

example in the spreadsheet:
enter data in C16
search column C for the first repeat of data starting at current entry(C16) if found(C9)
pulls data from column G(G9) and enters it in column J of current entry (J16)
then pull data from column I (I9) and enters it in column K of current entry (K16)

A Count	B Logged by	C Associate	D Department	E Key #	F Time out	G Checked Out	H Returned	I Report #	J Last Violation	K Previous Report#	L Property
(row6)	Mike L	Test Subject	hskp	A1	72.00	8/30/19 0:00	9/2/19 0:00	19-IR-000			3709
(row7	Mike L	Test Subject	hskp	A2	48.00	9/1/19 0:00	9/3/19 0:00	19-IR-001	8/30/19 0:00	19-IR-0000	3709
(row8	Mike L	Ron J	hskp	A3	48.00	9/2/19 0:00	9/4/19 0:00	19-IR-002			3709
(row9	Mike L	Kevin S	hskp	A4	48.00	9/3/19 0:00	9/5/19 0:00	19-IR-003			1039
(row10	Mike L	Benda D	hskp	A5	48.00	9/4/19 0:00	9/6/19 0:00	19-IR-004			1039
(row11	Mike L	Mike H	hskp	A6	48.00	9/5/19 0:00	9/7/19 0:00	19-IR-005			1039
(row12	Mike L	Mike K	hskp	A7	48.00	9/6/19 0:00	9/8/19 0:00	19-IR-006			1039
(row13	Mike L	Sammy P	hskp	A8	48.00	9/7/19 0:00	9/9/19 0:00	19-IR-007			3709
(row14	Mike L	George B	hskp	A9	48.00	9/8/19 0:00	9/10/19 0:00	19-IR-008			1039
(row15	Mike L	Ron J	hskp	A10	48.00	9/9/19 0:00	9/11/19 0:00	19-IR-009			1039
(row16	Mike L	Kevin S	hskp	A11	48.00	9/10/19 0:00	9/12/19 0:00	19-IR-010	9/3/19 0:00	19-IR-003	3709
(row17	Mike L	Benda D	hskp	A12	48.00	9/11/19 0:00	9/13/19 0:00	19-IR-011			1039
(row18	Mike L	Mike H	hskp	A13	48.00	9/12/19 0:00	9/14/19 0:00	19-IR-012			3709
(row19	Mike L	Ron J	hskp	A14	48.00	9/13/19 0:00	9/15/19 0:00	19-IR-013			1039
(row20	Mike L	Kevin S	hskp	A15	48.00	9/14/19 0:00	9/16/19 0:00	19-IR-014	9/10/19 0:00	19-IR-010	1039
(row21	Mike L	Benda D	hskp	A16	48.00	9/15/19 0:00	9/17/19 0:00	19-IR-015			1039
(row22	Mike L	Kevin S	hskp	A17	96.00	9/16/19 0:00	9/20/19 0:00	19-IR-016			3709

<colgroup><col><col><col><col><col><col><col><col span="4"><col></colgroup><tbody>
</tbody>

 

[kweaver]

How do J & K get their data in rows 7 & 20 ?

 

[kweaver]

I'm guessing, but maybe you want to always be looking back (not always row 16) like this??

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L
1	Count	Logged by	Associate	Department	Key #	Time out	Checked Out	Returned	Report #	Last Violation	Previous Report#	Property
2
3
4
5
6	(row6)	Mike L	Test Subject	hskp	A1	72	8/30/2019 0:00	9/2/2019 0:00	19-IR-000			3709
7	(row7	Mike L	Test Subject	hskp	A2	48	9/1/2019 0:00	9/3/2019 0:00	19-IR-001	8/30/2019 0:00	19-IR-000	3709
8	(row8	Mike L	Ron J	hskp	A3	48	9/2/2019 0:00	9/4/2019 0:00	19-IR-002			3709
9	(row9	Mike L	Kevin S	hskp	A4	48	9/3/2019 0:00	9/5/2019 0:00	19-IR-003			1039
10	(row10	Mike L	Benda D	hskp	A5	48	9/4/2019 0:00	9/6/2019 0:00	19-IR-004			1039
11	(row11	Mike L	Mike H	hskp	A6	48	9/5/2019 0:00	9/7/2019 0:00	19-IR-005			1039
12	(row12	Mike L	Mike K	hskp	A7	48	9/6/2019 0:00	9/8/2019 0:00	19-IR-006			1039
13	(row13	Mike L	Sammy P	hskp	A8	48	9/7/2019 0:00	9/9/2019 0:00	19-IR-007			3709
14	(row14	Mike L	George B	hskp	A9	48	9/8/2019 0:00	9/10/2019 0:00	19-IR-008			1039
15	(row15	Mike L	Ron J	hskp	A10	48	9/9/2019 0:00	9/11/2019 0:00	19-IR-009	9/2/2019 0:00	19-IR-002	1039
16	(row16	Mike L	Kevin S	hskp	A11	48	9/10/2019 0:00	9/12/2019 0:00	19-IR-010	9/3/2019 0:00	19-IR-003	3709
17	(row17	Mike L	Benda D	hskp	A12	48	9/11/2019 0:00	9/13/2019 0:00	19-IR-011	9/4/2019 0:00	19-IR-004	1039
18	(row18	Mike L	Mike H	hskp	A13	48	9/12/2019 0:00	9/14/2019 0:00	19-IR-012	9/5/2019 0:00	19-IR-005	3709
19	(row19	Mike L	Ron J	hskp	A14	48	9/13/2019 0:00	9/15/2019 0:00	19-IR-013	9/2/2019 0:00	19-IR-002	1039
20	(row20	Mike L	Kevin S	hskp	A15	48	9/14/2019 0:00	9/16/2019 0:00	19-IR-014	9/3/2019 0:00	19-IR-003	1039
21	(row21	Mike L	Benda D	hskp	A16	48	9/15/2019 0:00	9/17/2019 0:00	19-IR-015	9/4/2019 0:00	19-IR-004	1039
22	(row22	Mike L	Kevin S	hskp	A17	96	9/16/2019 0:00	9/20/2019 0:00	19-IR-016	9/3/2019 0:00	19-IR-003	3709
Sheet15

Cell Formulas
Range	Formula
J7	=IFERROR(INDEX($G$1:G6,MATCH(C7,$C$1:C6,0),1),"")
K7	=IFERROR(INDEX($I$1:I6,MATCH(C7,$C$1:C6,0),1),"")

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; mso-bidi-font-size:11.0pt; font-family:"Times New Roman","serif"; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]-->

 

[kweaver]

Why in your example doesn't row 22 pull data from row 20?

 

[kweaver]

Maybe I understand...head scratch! What about:

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L
1	Count	Logged by	Associate	Department	Key #	Time out	Checked Out	Returned	Report #	Last Violation	Previous Report#	Property
2
3
4
5
6	(row6)	Mike L	Test Subject	hskp	A1	72	8/30/2019 0:00	9/2/2019 0:00	19-IR-000			3709
7	(row7	Mike L	Test Subject	hskp	A2	48	9/1/2019 0:00	9/3/2019 0:00	19-IR-001	8/30/2019 0:00	19-IR-000	3709
8	(row8	Mike L	Ron J	hskp	A3	48	9/2/2019 0:00	9/4/2019 0:00	19-IR-002			3709
9	(row9	Mike L	Kevin S	hskp	A4	48	9/3/2019 0:00	9/5/2019 0:00	19-IR-003			1039
10	(row10	Mike L	Benda D	hskp	A5	48	9/4/2019 0:00	9/6/2019 0:00	19-IR-004			1039
11	(row11	Mike L	Mike H	hskp	A6	48	9/5/2019 0:00	9/7/2019 0:00	19-IR-005			1039
12	(row12	Mike L	Mike K	hskp	A7	48	9/6/2019 0:00	9/8/2019 0:00	19-IR-006			1039
13	(row13	Mike L	Sammy P	hskp	A8	48	9/7/2019 0:00	9/9/2019 0:00	19-IR-007			3709
14	(row14	Mike L	George B	hskp	A9	48	9/8/2019 0:00	9/10/2019 0:00	19-IR-008			1039
15	(row15	Mike L	Ron J	hskp	A10	48	9/9/2019 0:00	9/11/2019 0:00	19-IR-009	9/2/2019 0:00	19-IR-002	1039
16	(row16	Mike L	Kevin S	hskp	A11	48	9/10/2019 0:00	9/12/2019 0:00	19-IR-010	9/3/2019 0:00	19-IR-003	3709
17	(row17	Mike L	Benda D	hskp	A12	48	9/11/2019 0:00	9/13/2019 0:00	19-IR-011	9/4/2019 0:00	19-IR-004	1039
18	(row18	Mike L	Mike H	hskp	A13	48	9/12/2019 0:00	9/14/2019 0:00	19-IR-012	9/5/2019 0:00	19-IR-005	3709
19	(row19	Mike L	Ron J	hskp	A14	48	9/13/2019 0:00	9/15/2019 0:00	19-IR-013	9/9/2019 0:00	19-IR-009	1039
20	(row20	Mike L	Kevin S	hskp	A15	48	9/14/2019 0:00	9/16/2019 0:00	19-IR-014	9/10/2019 0:00	19-IR-010	1039
21	(row21	Mike L	Benda D	hskp	A16	48	9/15/2019 0:00	9/17/2019 0:00	19-IR-015	9/11/2019 0:00	19-IR-011	1039
22	(row22	Mike L	Kevin S	hskp	A17	96	9/16/2019 0:00	9/20/2019 0:00	19-IR-016	9/14/2019 0:00	19-IR-014	3709
Sheet15

Cell Formulas
Range	Formula
J7	{=IFERROR(INDEX($G$2:G6,MAX((C7=$C$2:C6)*ROW($2:6))-1,1),"")}
K7	{=IFERROR(INDEX($I$2:I6,MAX((C7=$C$2:C6)*ROW($2:6))-1,1),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Mike Luce]

How do J & K get their data in rows 7 & 20 ?

row 7 pulled from row 6

row 20 pulled from row 16