01-08-2006, 05:10 PM
|
|
|
|
Re: Help with creating an exam book..
Hi Sarrah
My original Vlookup, assumed you were going across the page in your
form, not down the page.
It also assumed that you were starting your data in cell A2 of Sheet2,
which I don't think is the case, I think it starts with B26.
That being the case, then on your form enter the following into cell D8
=VLOOKUP($D$7,Sheet2!$B$26:$F$100,ROW(2:2),0)
Copy down through the cells below.
I have just noticed you have row 10 hidden. Why?
If that is the case, then the formula will not work as you copy down,
you may need to hard code each cell as you want the offset
(where I have ROW(2:2)) to be 2 for cell D8, 3 for D9, 4 for D11, 5 for
D12.
--
Regards
Roger Govier
"Sarrah" <Sarrah.21c5xm_1136757301.3412@excelforum-nospam.com> wrote in
message news:Sarrah.21c5xm_1136757301.3412@excelforum-nospam.com...
>
> Ahh it worked, thanks for the help!!
>
> I need help with one thing more, about Vlookup, I dunno how to do it
> I've tried what you told me before but it doesn't work oh and I don't
> have any header on any page.. what I want to do is, type a student
> number on first black and it should lookup all the value from sheet2
> and give me information for name, age, ***, and group, how would I do
> that?
>
> My Resultform sheet looks something like this:- 'CLICK HERE'
> (http://img417.imageshack.us/img417/8030/image20if.jpg)
>
>
> --
> Sarrah
> ------------------------------------------------------------------------
> Sarrah's Profile:
> http://www.excelforum.com/member.php...o&userid=30223
> View this thread:
> http://www.excelforum.com/showthread...hreadid=499013
>
|