Link to a row in a different sheet based on a particular criteria

SharonH

I have a Gantt Chart with information for a number of projects.

I would like to link the the task name, duration, start & finish date, % complete and status of my top 10 projects to another separate summary sheet.

I have a column Project# which identifies each project with a number i.e 1,2, 3 etc

Can I pull through all the information to my second sheet based on the project number? I don't want to copy the row as the project number may change e.g. project 1 may become 11 and project 1 be replaced by a different project. The information would then change as the project changes.

I can pull through the task name using INDEX/MATCH but I can't make this work for the duration, date, % fields. Possibly because the look up value is a number and these are dates, %s etc.

This is the MATCH/INDEX formula I have used for the task name

=INDEX({Projects 2024 Range 2}, MATCH(1, {Projects 2024 Range 1}, 0))

Can anyone help with linking the task name plus the duration, start & finish date, % complete and status info in the row using the Project# column for the criteria?

Thanks

Paul Newcome

Have you looked into creating a row report instead?

SharonH

Yes I have that however can I link rows into a separate Gantt chart from a row report?

Paul Newcome

No, but you can apply Gantt view to the report.