V Lookup Function to make a Score Card

we need to make a score card using the vlookup function, when we choose the student number from a drop down list, it should give us its name and the grades he got.

THanks

Originally Posted by VBA Noob

Hi,

This site shows ou examples on both vlookup's and dropdowns


Vlookup
http://www.contextures.com/xlFunctions02.html

Dropdowns
http://www.contextures.com/xlDataVal01.html

VBA Noob

Thanks for the links, It was really helpfull!!!!