Is there a way to search all sheets in a workspace to find a matching value?
I have multiple project plan sheets in a workspace which are each identifiable by a unique project number in a particular column of the sheet. In another sheet elsewhere, I want to create a formula which will search all of the project plans and find the one with a particular project number (eg PN123) then look up and return info from a cell (or cells) on that sheet. Is that possible? Thanks :)
Help Article Resources
Check out the Formula Handbook template!