for a specific work date of an employees bring back rate that falls between 2 dates

Picture1.jpg

Hello - I am trying to compare two tables. Table 1 has multiple employees with work dates. Table 2 has the rates the employee had during a timeframe.
Need to bring back the rate to table 1 if the work date fell between the dates in table 2 for that employee.
Appreciate any help!

Thanks!

update - edit:
looks like my pcture of tables did not post. here it is written out:

TABLE 1

PERSONNUM - Work Date
103649934 - 11/9/2013
103985360 - 2/27/2014
103985360 - 3/6/2014
103985360 - 10/8/2013
103985360 - 2/19/2014
103985360 - 10/3/2013

TABLE 2

PERSONNUM - Start -- End --- Hourly Rate
103649934 - 7/8/2012 -- 10/14/2012 --- $14.26
103649934 - 10/14/2012 -- 7/23/2013 --- $15.01
103649934 - 7/23/2013 -- 5/12/2014 --- $15.31
103649934 - 5/12/2014 -- 6/25/2014 --- $16.00
103649934 - 6/25/2014 -- 7/6/2014 --- $16.48
103649934 - 7/6/2014 -- 1/1/3000 --- $16.80
103985360 - 7/8/2012 -- 10/14/2012 --- $14.26
103985360 - 10/14/2012 -- 7/23/2013 --- $15.01
103985360 - 7/23/2013 -- 5/11/2014 --- $15.31
103985360 - 5/11/2014 -- 7/6/2014 --- $16.00
103985360 - 7/6/2014 -- 1/1/3000 --- $16.80

Hi, welcome to the forum

See if this will give you what you want?

=SUMPRODUCT(($F$2:$F$12=A2)*($G$2:$G$12<=B2)*($H$2:$H$12>=B2),($I$2:$I$12))

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)