how do I use vlookup in excell 2007?

[trainerjones]

I can't seem to get the vlookup to work for a multi-page workbook

 

[Toppers]

..... and your formula (and data) is ?

 

[Dave Peterson]

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) here:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))