I have an existing report that I need to add a vlookup feature. I have removed the extraneous columns, but need to add a column that will pull from the DATA tab the most recent date of a data upload for a project. Unfortunately, the DATA tab lists the Project ID multiples times with both blanks and all the dates of an upload. I just need to pull the most recent date for the project onto the the report tab.
Obviously, as more uploads are done for a project, the size of the table will change on the DATA tab. Any help you can provide a newbie would be greatly appreciate. I have attached the stripped down file and would thank you in advance for your help. If there are any additional answers you need or questions, please let me know. MARC