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

 

[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))

Thank you very much ill give a try