formula to point to a sheet

[gn82]

Can anyone help me with an elegant solution for pointing at a spreadsheet name automatically?

I have a few sheets called 1999, 2000, 2001 and so on and I would like to point to them from an ID list instead of writing the sheet's name

Main sheet
<table frame="VOID" rules="NONE" border="0" cellspacing="0" cols="5"><colgroup><col width="28"><col width="28"><col width="28"><col width="28"><col width="28"></colgroup><tbody><tr><td align="CENTER" height="18" width="28">
</td><td align="CENTER" width="28">A</td><td align="CENTER" width="28">B</td><td align="CENTER" width="28">C</td><td align="CENTER" width="28">D</td></tr><tr><td align="CENTER" height="18">1</td><td align="CENTER">ID</td><td align="CENTER">Student</td><td align="CENTER">Class</td><td align="CENTER">Grade</td></tr><tr><td align="CENTER" height="17">2</td><td align="CENTER">1999</td><td align="CENTER">Mike</td><td align="CENTER">Physics</td><td align="CENTER">9</td></tr><tr><td align="CENTER" height="18">3</td><td align="CENTER">2000</td><td align="CENTER">Mike</td><td align="CENTER">Physics</td><td align="CENTER">10</td></tr><tr><td align="CENTER" height="18">4</td><td align="CENTER">2001</td><td align="CENTER">Mike</td><td align="CENTER">Physics</td><td align="CENTER">10</td></tr></tbody> </table>
D2=VLOOKUP(B3;'1999'.$H$2:$I$21;2;0)

How can I make sure Vlookup points to A2 in the current sheet instead of taking the numerical 1999 value for the sheet's name?

Thanks in advance !

 

[shg]

Your syntax is wrong:

=VLOOKUP(B3; '1999'!$H$2:$I$21; 2; 0)

 

[gregtx81]

I'm not completely following your example, but I bet the INDIRECT function is what you're looking for.