VBA if question

[asreid2527]

I am trying to use VBA to input a value into a cell on sheet1 based on criteria but have no idea how to do this. Here is the case scenario:

Sheet1: (Contains call data including the extension number in one column and the date the call came in on that extension in another column.)

Sheet2: Contains the list of extensions with the assigned employee and the start and end date of the employee).

I can't just do a vlookup on this since the extension is listed multiple times in the same column on sheet 2 with different employees (same extension is used when a new employee starts).

I would assume an if statement would be used such as:

if sheet1 row 1 date is between sheet2 start and end date and sheet1 extension = sheet2 extension, then input the employee name(stored from sheet2) into sheet1 row X1.

Any help on this would be greatly appreciated!

Thanks