Row Lookup

Carrie Lucas

I have multiple project sheets with row items that are the same on each sheet and each row has a percentage of completion. I am trying to create a new summary sheet that has each row item as a column and return the percentage of completion. ie: row items "excavation, framing" etc. are column headings on the new summary sheet with corresponding completion percentage populating from the rows on the project sheets so we can see which projects are excavated, framed etc. Is this possible?

Paul Newcome

I would suggest a row report that can be grouped by "excavation, framing" etc..