Vlookup w/Name field based on Program ID

Microsoft Excel 2010 software
October 28, 2010 at 13:54:15
Specs: Windows XP
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?


See More: Vlookup w/Name field based on Program ID

October 29, 2010 at 07:52:32
Look up the INDIRECT function in the Excel help files.

INDIRECT returns the reference specified by a text string.

e.g. with MAST in B2, this formula would be equivalent to yours:


Report •
Related Solutions

Ask Question