I need help with finding a max/min date within a VLOOKUP. I have fried my brain
Overview: When working with students, I need to know specific information about their particular class, defined as “CRN” number.
The Master Sheet acts as my database for all the college classes this semester. The Fee Page is where I can type in the CRN into the yellow section and the remaining fields populate with the corresponding data from the Master Sheet.
Each row is 1 record in the Fee Page that shows the info I need for each college class. The CRN 10596 (criteria) shows Start Date of 9-Dec-15 and an End Date OF 9-Dec-15.
The existing formula for Start Date P2 is =IFERROR(VLOOKUP(TEXT($A2,"0"),Master!$1:$10001,COLUMN(),FALSE),IFERROR(VLOOKUP($A2,Master!$1:$10001,COLUMN(),FALSE),""))
The actual dates of the class are 19-Aug-15 through 9-Dec-15. I highlighted the cells that contain CRN 10596 start and end dates in the master sheet in blue. I have used the MAX and MIN function before but I can’t the formula to work. I am including the workbook for reference. Any ideas?
Thanks so much for your assistance!
Bookmarks