i have attached my sheet. I want to select the class which in turn will produce a name of the range next to it. With that named range I would like to look up the value in corresponding cells with V look up function. Is there a way to have vlookup look for the name selected in cell C2 with in the range that will appear in cell B2 and change dynamically when ever a new student is selected?
Thank you for the read and the help
jim
Bookmarks