Arvind Shankar Raj
New Member
Hello,
Need your help on Vlookup.
I am aware that the VLOOKUP will only fetch the first result from the table. Is there any way to pull the 2nd or the 3rd value from the table.
For example: In the table below, is there a way for me to get the Planned Date and Actual Visit date for a particular Hospital No. for the month of October ?
when I use =Vlookup(100,A:D,4,0) I am getting 23-May19 which was long while ago. Now if I need the date for August what should I do ? and also is there a way to get the latest Visit completed date ?
I have attached this data in excel sheet also for your easy access.
Need your help on Vlookup.
I am aware that the VLOOKUP will only fetch the first result from the table. Is there any way to pull the 2nd or the 3rd value from the table.
For example: In the table below, is there a way for me to get the Planned Date and Actual Visit date for a particular Hospital No. for the month of October ?
when I use =Vlookup(100,A:D,4,0) I am getting 23-May19 which was long while ago. Now if I need the date for August what should I do ? and also is there a way to get the latest Visit completed date ?
I have attached this data in excel sheet also for your easy access.
Hosptial No. | Visit Status | Planned Date | Actual Visit Date |
100 | Visit Completed | 23-May-19 | 23-May-19 |
101 | Visit Completed | 11-Jun-19 | 01-Jun-19 |
102 | Visit Completed | 17-Jul-19 | 17-Jul-19 |
100 | Visit Completed | 07-Aug-19 | 07-Aug-19 |
101 | Visit Completed | 11-Sep-19 | 11-Sep-19 |
102 | Visit Completed | 16-Sep-19 | 16-Sep-19 |
100 | Visit Completed | 10-Oct-19 | 10-Oct-19 |
101 | Visit Completed | 15-Oct-19 | 15-Oct-19 |
102 | Confirmed | 23-Oct-19 | 23-Oct-19 |
100 | Planned | 11-Nov-19 | 11-Nov-19 |
101 | Planned | 03-Dec-19 | 03-Dec-19 |
102 | Planned | 10-Dec-19 | 10-Dec-19 |
100 | Planned | 31-Dec-19 | 31-Dec-19 |
101 | Visit Completed | 18-Sep-19 | 08-Oct-19 |
102 | Planned | 24-Oct-19 | 24-Oct-19 |
100 | Planned | 19-Sep-19 | 05-Nov-19 |
101 | Planned | 09-Oct-19 | 06-Nov-19 |
102 | Planned | 18-Dec-19 | 18-Dec-19 |
100 | Visit Completed | 15-Feb-19 | 08-Feb-19 |
101 | Visit Completed | 26-Mar-19 | 26-Mar-19 |