I have two tables, a summary table and a documents_list table. The summary table does a lookup on the documents_list table to determine the latest version of the document (several exist), and then returns the document name, version number, date and author into the cell. The reason for the Concatenation, is that the lookup is done on the services ([@Services]), the type (D$1) and whether the document is the latest version ('Yes')The formula is as follows and works fine.
=IF(ISNA(VLOOKUP(CONCATENATE([@Services],D$1,"Yes"),Lookup_Data,2,FALSE)),
"",
CONCATENATE(VLOOKUP(CONCATENATE([@Services],D$1,"Yes"),Lookup_Data,2,FALSE),CHAR(10),CHAR(13),
TEXT(VLOOKUP(CONCATENATE([@Services],D$1,"Yes"),Lookup_Data,5,FALSE),"dd-mmm-yy"),", ",
VLOOKUP(CONCATENATE([@Services],D$1,"Yes"),Lookup_Data,4,FALSE),CHAR(10),CHAR(13),
VLOOKUP(CONCATENATE([@Services],D$1,"Yes"),Lookup_Data,6,FALSE),CHAR(10),CHAR(13),
VLOOKUP(CONCATENATE([@Services],D$1,"Yes"),Lookup_Data,21,FALSE)))
I would like to do a vlookup on the "notes' field from the documents_list table and have the contents of the cell populate the comment for that cell in the summary table.
The vlookup formula to get the "notes" field from the documents_list table would is:
=VLOOKUP(CONCATENATE([@Services],D$1,"Yes"),Lookup_Data,22,FALSE)
Not all the cells are populated, so I only want comments on cells with content, and ONLY want a comment, if something exists in the notes field.
Can someone help with the VBA code to do this?
Trish
Bookmarks