Hi,

I'm new to the forum and a definite novice compared to most on here. Anyway hope you can help with the following problem.

I'm basically need to do a complex vlookup statment but I'm not sure if it is the correct or easiest way to do it.

In my new spreadsheet I'm searching for a project I.D. eg. "1000".

In the source data spreadsheet the Project I.D. is in Column 1.

What I need to do is search the columns to the immediate right of the Project ID which have headings: "Milestone 1 Description" and "Milestone 1 Date". up to "Milestone 10 Description" and Milestone 10 Date". So 21 Columns in total including the project ID.

What I need to do is search along the row with Project I.D "1000" until I get a description "Project Completion". If this description is in the column "Milestone 3 Description" I then want the formula to return the details in "Milestone 3 Date".

Hope the above is clear and if so those anyone have an idea of how to do it?

Thanks in advance.