Re: Help with creating an exam book..

Hi Sarah

With headers in row 1 on each sheet, and assuming the data on sheet2
starts with Student Number in Column A, and with data extending to
Column F, then maybe something like the following on Sheet1 cell B2

=VLOOKUP($A2,Sheet2!($A$2:$F$100,column(),0)
copied across through C2:F2, then the whole range B2:F2 copied down for
as many rows as required.
Change ranges to suit.

--
Regards

Roger Govier


"Sarrah" <Sarrah.21agtm_1136678100.8158@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:Sarrah.21agtm_1136678100.8158@xxxxxxxxxxxxxxxxxxxxxxxx
>
> All I want to know is that what formula would I need to get all these
> informations from one *** to another by typing just student no.
> thanks, I'll be waiting for the answer I really really do need help
> and
> quickly too..
>
>
> --
> Sarrah
> ------------------------------------------------------------------------
> Sarrah's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=30223
> View this thread:
> http://www.excelforum.com/showthread.php?threadid=499013
>


.