Help with looking up information

[Needing Help]

I have been given the following problem to resolve in Excel and require some
help:

I have a Master Job sheet where I am to input information on Job Numbers,
which uses VLOOKUPs to find out the job description and start and end date.

This informaiton is then filtered through to a sheet where an individual job
number is typed in and VLOOKUPs are used to pull through the start and end
date again, however I have been asked to pull out the following information
from the Master Sheet:

Type of Work1
Date, Type of work, Staff, Hours

Type of Work2
Date, Type of work, Staff, Hours

Type of Work3
Date, Type of work, Staff, Hours

I have no idea of where to start pulling this information through. My
problem is that there are multiple entries (by date) per job number and
VLOOKUPs will not work. Any ideas?

The Master Job sheet is purely an input sheet and items are added as they
occur.

Hopefully someone can help.

Thanks

 

[joel]

It sounds like yo will need a macro to perform the task rather than a lot of
formulas. look at the Excel programming postings for some ideas.

 

[Gary''s Student]

Perhaps:

http://office.microsoft.com/en-us/excel/HA012260381033.aspx

 

[Needing Help]

Thanks for that, it looks like it could work. I just need to have a go at
writing up a formula which works.