Lookup macro

[firedude]

Help

I'm new to VB in Excel and I'm trying to create a lookup macro. I have several columns that are filled with data but I'm only concerned with two of them. I would like to create a macro where when I type the id number in a userform it will spit out the hours for the particular individual (Jon Doe). Plus I need to put this Userform on another sheet so all the users can't see eachothers hours. Any guidance is greatly appreciated..

Thanks,
Fried Brain in Glendale

Id # Name Hours
0001 Jon Doe 12

 

[P Sitaram]

See below:

Book1
	A	B	C	D	E	F
1	Name	Hours			Name	Hours
2	JonDoe	12			SomeOne	11
3	SomeOne	11
4	OtherOne	4
Sheet1

Cell F2 holds the formula:

=INDEX(B:B,MATCH(E2,A:A,0))

E1:F2 can be placed in another worksheet. The range references should contain the sheet name in that case.

Restricting people to their own data will be difficult. It will require some VBA and other preventive steps, to attain a reasonable level of security.