Modifying an index/match forumla to include additional cells

**trishcollins** · 03-13-2014, 08:48 AM

With the help of this forum, I was able to resolve an question concerning match, index. However, I now want to add two more fields to the same results:

Document_List[Document Name]
Document_List[Author]

Current the results look like this:

WIP v1.0 -- 28-Oct-13

I want the results to look like this:

GS Registry Service Definitions, John Doe, WIP v1.0 -- 28-Oct-13

Here is the current formula:

=IF(ISNA(INDEX(Document_List[Version in File Revision],MATCH(CONCATENATE([@Services]&"SD")&"_"&MAX(IF(Document_List[Lookup]=CONCATENATE([@Services]&"SD"),Document_List[Document Date])),Document_List[Lookup]&"_"&Document_List[Document Date],0))&TEXT(MAX(IF(Document_List[Lookup]=CONCATENATE([@Services]&"SD"),Document_List[Document Date]))," d-mmm-yy")),
"",
INDEX(Document_List[Version in File Revision],MATCH(CONCATENATE([@Services]&"SD")&"_"&MAX(IF(Document_List[Lookup]=CONCATENATE([@Services]&"SD"),Document_List[Document Date])),Document_List[Lookup]&"_"&Document_List[Document Date],0))&" --"&TEXT(MAX(IF(Document_List[Lookup]=CONCATENATE([@Services]&"SD"),Document_List[Document Date]))," d-mmm-yy"))

Just not sure were to add the extra fields.

**AZ-XL** · 03-13-2014, 08:50 AM

Can you upload sample file?

**trishcollins** · 03-13-2014, 09:49 AM

Here is the file. The summary table pulls data from the document list table. Note that the summary pulls the document based on the newest (max) date (several versions and dates exist), and based on the service and type of document.