Thread: Help with creating an exam book..
View Single Post
  #12  
Old 01-08-2006, 06:01 PM
pinmaster pinmaster is offline
Banned User!
  
Join Date: 17 Feb 2004
Location: Canada
Posts: 517
pinmaster is becoming part of the community
Try this:

=VLOOKUP($A1,Sheet2!$B$26:$F$1000,COLUMN(B1),0)
copy across

HTH
JG
Reply With Quote