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:

Array Formulas Cell 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),"")} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

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

Thank you so much!!!!!

 

[kweaver]

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