Lookup multiple values

[anilswarrier]

Hello...
I am preparing an excel program for displaying the employees on leave today. Sheet "Master" is for entering the employee particulars and sheet "Data" for entering the leave particulars. Employees who are on leave today, should display in sheet"Today". Can you please provide a formula for displaying Branch and Designation. In this example, branch should be Bangalore and designation should be Chief Manager.(During this period, he is in Bangalore and working as Chief Manager.) The file is attached.

Can anybody provide a formula/macro/vba...
Thank in advance

Anil