Good afternoon All,

I have attached an extract of a document we are trying to create.

Our intention is to fill out the drawing history tab with;
Drawing No
Drawing Title
Drawn By

Followed on by the date each revision is issued. At the moment I have the sheet setup so that when you enter "x" into A it lists these drawings on the drawing transmittal.

The problem is that I would also like it to fill out the DAY/MONTH/YEAR on the drawing transmittal based on the revision.

i.e. Drawing Transmittal tab
Drawing 2 was issued 1st issue 01/06/14 and then revision A was issued 02/06/14. This I could probably get to work but the problem is, drawing 2 revision A was issued 03/06/14. Now this could happen numerous times for various revisions.

What I need to accomplish if its possible, is to have excel lookup the drawing number, list each revision complete with the date, however if the same revision letter appears then list it under each separate date.

It's quite confusing to explain in text but hopefully the attached spreadsheet makes it clearer and I'll happily explain/clarify anything I can.

Any helps, assistance or guidance is much appreciated. Ideally I want to do it with a formula which self regulates as this spreadsheet will be used by various members of staff with differing levels of excel skill levels.

Thanks in advance,

Alan.
Excel Forum - Drawing Register & History Example.xlsx