excel - Copying data from one cell to another based on the value of another cell -

excel - Copying data from one cell to another based on the value of another cell -

i trying create heat sheet updates names according position.. top 2 each heat go round 2 , seeded heats according position..

so h1 r1 winner goes go r2 h1 in illustration below need move deee r2 h1

so heat 1 round 1 |colour | name | position| |red | abbb | 3 | |white | bccc | 2 | |yellow | deee | 1 | |blue | fggg | 4 |

round 2 heat 1 |colour | name | position| |red | deee | | |white | bccc | | |yellow | | | |blue | | |

eg if position in (c2:c5) = "1" name in "b2" copied "g5"

don't know if looking for. idea...

assuming first heat table in columns c first row beingness header , next rows info , column 3 holding position.

you have sec heat table e.g. column "e" holding new position numbers , column "f" follwing formular

=offset($a$1;match(e1;$c$2:$c$5;0);1)

shows name in new heat table according position in original table.

| b | c | d | e | f colour | name | pos | |new pos|-formular-

excel