excel - If a value in one column matches the value in another column, copy the name in the cell next to the match -
if number in column b has match in column h, want copy representatives name in column g column c next match.
here's example in google sheets.
https://docs.google.com/spreadsheets/d/1wksl7kyodra5lulxtnxa6pcbeekeh86_bljogycrgra/edit?usp=sharing
enter below formula in cell c2 , drag down,
=index(g:g,match(b2,h:h,0),1)
Comments
Post a Comment