Dear All,
I have a criteria to lookup a project ID status in sheet 2 based on the latest DATE, any formula i can use to perform this function.
Vlookup based on the latest date in excel
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Vlookup based on the latest date in excel
Please attach a small sample workbook without sensitive data.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
Re: Vlookup based on the latest date in excel
Dear Hans,
Attached herewith is the workbook, where i need to find the project status based on the latest date in raw data sheet.
Attached herewith is the workbook, where i need to find the project status based on the latest date in raw data sheet.
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Vlookup based on the latest date in excel
See the attached version. The formula had to take into account that there were 2 rows with the latest date for project 1.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
Re: Vlookup based on the latest date in excel
Hi Hans,
The file is excellent , solve my problem. Thanks a lot
The file is excellent , solve my problem. Thanks a lot