Jan 17 2022 06:17 AM
I'm currently attempting to make cells populate if a few conditions are true. Below is a snapshot from the table on what I'm attempting. The information below is from a table that forms the policy index for that specific set of Clauses. So this one is "Section 1" and is on its own tab. The full list of all documents are their own tab. The goal is to find in the full list of documents the specific Document Number and return the information for Date Reviewed, Review Frequency, Review Date, and Author. This will help form a snapshot on the index which is placed in the binder when everything is due for that specific section. It will also keep the index updated since the main list of documents is where updates always occur. What would be really amazing is if all this could also be tied to the actual policy word document, but I'll save that for another question!
Policy | Document Number | BRC Number | Full Doc | Version # | Date Reviewed | Review Frequency | Review Due | Author | ||
Product Safety & Quality Culture | 1111 | 1 | 1111.01 | 1 | = |
Jan 17 2022 06:33 AM
=VLOOKUP($A4,$G$4:$K$10,COLUMN(B1),FALSE)
Maybe with the above formula as shown in the attached file. If you work with Office365 or 2021 you can as well apply XLOOKUP.
Jan 17 2022 07:24 AM
Jan 17 2022 12:19 PM
Maybe as in the attached file.