Hi everbody,
My question is about looking up a value in a table using date periods. I have two sheets in a workbook: A en B. Sheet A contains the location code for a employee during different periods, for example
Empno DateBegin DateEnd LocationCode
1215 01052009 28022010 1050
1215...