View Single Post
  #6   Report Post  
mr_shocker2002 mr_shocker2002 is offline
Junior Member
 
Posts: 5
Default

Quote:
Originally Posted by mr_shocker2002 View Post
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