Vlookup ID and Return Data if Date Falls Within Range

Hello,

I have Tab A with Employee IDs [a], Start Date [b], End Date [c], Location [d]. Employee's appear multiple times with different start and end dates and location may vary or stay the same. On Tab B I have Employee ID [a], Start Date [b], End Date [c], Salary [d]. And the same rule applies as Tab A, they may appear multiple times with the Start & End Dates and salary my change or stay the same.

I would like a formula or VBA that searches for the ID in A2 from the array TAB b a2:d4, finds the row where the date falls within the start & end date on Tab a, and returns the salary.

Tab A

ID | START | END | LOCATION | SALARY
1234 | 01/01/2014 | 06/16/2014 | DENVER | 50,000
1234 | 06/17/2014 | 09/30/2014 | ASPEN | 53,000
1234 | 10/01/2014 | 12/31/2014 | ASPEN | 53,000
3456 | 01/01/2014 | 12/31/2014 | ASPEN | 20,000

Tab B

ID | START | END | SALARY
1234 | 01/01/2014 | 06/16/2014 | 50,000
1234 | 06/17/2014 | 12/31/2014 | 53,000
3456 | 03/01/2014 | 12/31/2014 | 20,000


Thanks!

Start with this. You will need to adjust for your purposes.

VLookup should work for you. Might give a good starting point

=VLOOKUP(A2,'Tab B'!A2:D4,4)

Sorry had misread your post. I have used the following and seems to work.
=SUMPRODUCT(--(Sheet2!B1:B4>=B3), --(Sheet2!C1:C4<=C3), --(ISNUMBER(MATCH(Sheet2!A1:A4, A3,0))), Sheet2!E1:E4)

LOOKUP HELP.xlsxFDibbins, could you load your suggested formula in this worksheet please.