reporting from excell workbook

[acomputer4u]

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

 

[Bernard Liengme]

Try VLOOKUP to lookup student in each of the four areas
best wishes

 

[acomputer4u]

kool,I've got the vlookup going but how do you show multiple values?

 

[acomputer4u]

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

 

[Gord Dibben]

More vlookups.

One for each piece of data you want returned.


Gord Dibben MS Excel MVP