Vlookup

[Denise B]

Hello,

I have a list where I am doing a look up from another
sheet based on an employees ID number. The 2nd spread
sheet is a listing of all the employee activites they did
that day expressed through different codes. My question
is how do I bring back all the information if using a
vlookup only brings back the first match and some
employees have multiple activity codes for that day.
Is there a function out there to solve this problem?

Thank you,

Denise

 

[Tomek]

The easiest thing that comes to my mind is using PIVOT TABLES. In a column
drag employee ID, in data you can have your code counted, listed, sumed up
or whatever you need.

HTH (Hope that helps).
Tomek

 

[Alan Beban]

If the functions from the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, the
VLookups function will do what you indicated you need.

Alan Beban