Posted 04 April 2006 - 10:36 PM
Off hand, I don't think there's an easy way. To propagate a formula down or across, the destination cells need to be adjacent. I would suggest to redesign. In VBA, you could build a macro subroutine to do the job skipping the cells if they're really in predicable locations.
One possibility is something along the lines "if the column number is even, use VLOOKUP, else fill with "" (null, nothing)". That would allow to drag the formula, but I don't think it'll work for your design.
BTW, watch that last parameter (T/F) to make sure you get the EXACT hit on the student and not a student with a similar name. Also, unless your student list is always sorted, Vlookup will mess up. Read help about combination of MATCH and INDEX functions. They come handy and, while difficult to learn initially, they impose less restrictions than VLOOKUP.