First of all , Hello everyone .

My question is this ..Regarding a fantasy Football program i have.

I use Vlookup to gather information about a player (from a named range "players"

in a1 i input his code (through to k1)

cells b1,c1,d1,e1,f1 give me his Position,Name,Team,Value and current score
This happens 11 times to form the 11 players

We have 2 transfers a year where we swap 3 players and i use the same vlookup in cells m1,n1,o1 to register players out

and in q1,r1,s1, 3 players in ..I hope this makes some sense


what i want to do is put the 3 players transferred in into the cells of the 3 players transferring out in the original team of 11 ???

Any help greatly appreciated or a much easier way to do it ?