|I have a spreadsheet which I track students test scores which works great with the following vlookup. "=IF(D22>0,VLOOKUP(D22,MAST,2),"")"|
The location MAST is a name field on another tab and I can change that as I need based on 3 different program codes.
But now that I have mixed classes I want to be able to (for example) start in cell range B2:B35 type in their program codes then have the forumula look in example B2 for the program code, then using name manager go to the scores tab and locate the score.
On my score tab I have 9 columns (3 for each program). First column is Program ID (ex: MAST), second column is Score (ex: 75), 3rd is percentage (ex: 75%).
How can I have the foumlua look in B2 for the Program Code then go to the 2nd sheet where the scores are and return the correct value?