Looking up clients

Hi

This sounds like a job for a pivot table.

A quick run through:
Highlight your data range. Go to the Insert tab and click Pivot Table (left hand side).

On the right hand side of the screen, drag the Employee Name in to the Report Filter box. Drag Client in to the Row Labels box, Drag Department in to the Column Labels box, drag Hours in to the Values box.

There's plenty of information online about PTs. They are an extremely useful and powerful tool in Excel. They are easy to set up and well worth learning.

Cheers, Rob.

Thanks Rob for the help. However. my boss hates pivot Tables, so unless there is no other option I can't use it.

Ah, I thought you might have done a mock-up of how you would like the secondary table to appear. It will take me a bit longer to set this up.

Pete

Your data shows no variation between Employee and Department, i.e. Ruby is always in Dept. FA, Rosa is in Dept. M, so I'm not really sure how you want the data to look. Can you do a mock-up of the expected output?

Pete

Sample.xls

Pete

Here is the mock up. Changed some numbers and clients to give variation.

Are you really using Excel 2003? I have it working and was just about to post the file when I noticed your version number in your profile - I've used some functions which will not work in XL2003, so I'll need to change them if you need it to be compatible with that version.

Pete