Quote:
Originally Posted by mr_shocker2002
What i need to do is for Q2 through to AB2 to copy the data from the second sheet of d2 through toO2.
but then on the q3 it would need to copy the same data.
when we get to q5 it would need to copy the data from d3
so AMP1 information on the data sheet neeeds to be copied to rows 2,3,4 and AMP2 information gets copied to rows 5,6,7,8
|
ok. got it now
=VLOOKUP(LEFT($A2,4),'Test Sheet'!$A$3:$O$6,4,FALSE)
cheers