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]

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

because i missed the repeated name when mocking the data up

 

[Mike Luce]

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


[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J7[/TH]
[TD="align: left"]{=IFERROR(INDEX($G$2:G6,MAX((C7=$C$2:C6)*ROW($2:6))-1,1),"")}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K7[/TH]
[TD="align: left"]{=IFERROR(INDEX($I$2:I6,MAX((C7=$C$2:C6)*ROW($2:6))-1,1),"")}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]

This one solved it!!!!!!!!

Thank you so much!!!!!

 

[kweaver]

So, did I get it on this last go-round?