Retrieve value from a database based on another value

[jerry4all]

Hi all, Please I have a workbook database of Admission numbers and Names, I also have another workbook of results sheet for each student. I need a way I can link the two so that if I enter a name or Number in one cell, The corresponding Number or Name from the database will inputed in the specified cell.

Your help will be well appreciated

[Domski]

Sounds like VLOOKUP should do the trick.

Dom

[jerry4all]

yeah I tot of that, but I'm just getting involved in complex programming with excel so I'll appreciate an explanation on how to write the formular or code. thanks again

[Domski]

See attached for an example.

Dom

[jerry4all]

See attached for an example.

Dom

Thanks man... you're a life saver

[jerry4all]

Forgive me for being Oliver twist....
I've attached a sample of the result sheet I'm working with, I have subject teachers entering scores in the CAT column (each teacher is to enter the score against His subject ) for each student that I've represented on different sheets. I've locked all the formular cells so they dont get tampered with. but an issue arose, a teacher mistaking inputs his score against another subject...
Is there a way I can create user access for each teacher and have only the cell or row for the teacher's subject editable when the teacher logs in. Hope you understand....

[jerry4all]

See attached for an example.

Dom

I've been trying to play around with that formular. Now I want to be able to enter the names( combination of Name and surname from the table) in B1 and have the Id appear in B2...

i.e B1= Charles Taylor
B2= id of Charles(name) Taylor(surname)

Thanks

[Domski]

How's this? I've used Data Validation on the input cells to restrict what can be entered, you need to give your source ranges defined names if they are on another sheet like in this example.

About your question re limiting access could have a look at the Allow Users to Edit Ranges option on the Review tab in 2007. Other than that it would be a VBA solution but beware Excel is far from a secure system if any of this info is sensitive.

Dom