More vlookups.

One for each piece of data you want returned.


Gord Dibben MS Excel MVP


On Wed, 8 Nov 2006 15:03:01 -0800, acomputer4u
wrote:

I did the vlookup but how do you show more than one cell!!!

"Bernard Liengme" wrote:

Try VLOOKUP to lookup student in each of the four areas
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"acomputer4u" wrote in message
...
I have created a multi-sheet workbook for a school teacher. It has all
students for each quarter, with quarter,semester,half-year and yearly
totals.
What I also need to do is generate a single student report for the each of
the above. How is this possible to do? I am familiar with macros, and most
fomulas, name tables but not pivot tables. thanks