This is what I have so far but it returns 6/01/1900 which I cant figure out:
=INDEX(Master!W:AZ,0,(MAX(W:AZ,(MATCH($E$2,Master!$A:$A,0)))))
So the in the sheet I'm working on, I want to use E2 as my reference, and return the last cell with data from the corresponding row on sheet2, starting...