Need help with simple formula

[dasda34]

Hello Everyone ,

I would like to have formula in column C so duplicates from column A (together with column B) to match in column C,B (empty rows).


Thanks

 

[davesexcel]

Starting with this formulas in B2 and drag down.
Once you start entering yes/no in the cells the matching cells will update .
Do the same for column C

=IF(COUNTIF($A$2:A2,A2)>1,VLOOKUP(A2,A$2:B2,2,FALSE),"")

 

[dasda34]

Starting with this formulas in B2 and drag down.
Once you start entering yes/no in the cells the matching cells will update .
Do the same for column C

=IF(COUNTIF($A$2:A2,A2)>1,VLOOKUP(A2,A$2:B2,2,FALSE),"")

Thanks for reply Dave, seems like something is wrong =IF(COUNTIF($A$2:A2,A2)>1,VLOOKUP(A2,A$2:B2,2,FALSE),"")

 

[dasda34]

Thanks for reply Dave, seems like something is wrong =IF(COUNTIF($A$2:A2,A2)>1,VLOOKUP(A2,A$2:B2,2,FALSE),"")

I would like to have formula in column C and B so duplicates from column A to match B and C

 

[dasda34]

I want to populate information to column B and C corresponding to the duplicate entries in column A

 

[hagia_sofia]

Do you mean this:

=INDEX(B2:C10;0;0)

inserted in B11?

 

[dasda34]

Do you mean this:

=INDEX(B2:C10;0;0)

inserted in B11?

No sorry that not work. Thanks for the try

 

[dasda34]

Starting with this formulas in B2 and drag down.
Once you start entering yes/no in the cells the matching cells will update .
Do the same for column C

=IF(COUNTIF($A$2:A2,A2)>1,VLOOKUP(A2,A$2:B2,2,FALSE),"")

This work thanks but the problem is when i try to drag down i lose the records that are already in the sheet .. is there a other way ?

 

[Burrgogi]

Sounds like a simple VLOOKUP is what you're looking for. Plug this into cell B11 and fill down:

=VLOOKUP(A11,$A$2:$C$10, 2, FALSE)

And plug this into cell C11 and fill down

=VLOOKUP(A11,$A$2:$C$10, 3, FALSE)

Another option would be use INDEX & MATCH together:

Cell B11 & fill down:

=INDEX($B$2:$B$10,MATCH(A8,$A$2:$A$10,0))

Cell C11 & fill down:

=INDEX($C$2:$C$10,MATCH(A8,$A$2:$A$10,0))

 

[dasda34]

Sounds like a simple VLOOKUP is what you're looking for. Plug this into cell B11 and fill down:

=VLOOKUP(A11,$A$2:$C$10, 2, FALSE)

And plug this into cell C11 and fill down

=VLOOKUP(A11,$A$2:$C$10, 3, FALSE)

Another option would be use INDEX & MATCH together:

Cell B11 & fill down:

=INDEX($B$2:$B$10,MATCH(A8,$A$2:$A$10,0))

Cell C11 & fill down:

=INDEX($C$2:$C$10,MATCH(A8,$A$2:$A$10,0))[/CODE
[/QUOTE]
Thank you very much  [USER=52733]Burrgogi[/USER] ill give a try