Multi Criteria VLookup with First Date

[fdfordham]

I am trying to perform a VLOOKUP with multiple criteria and the initial date of the range only, and the result is the value that corresponds to the last date. To explain, I have simplified some examples as follows:

I can perform a VLookup with only the initial date in the range (no gaps)

But can't do the same for multi-criteria

Thank you for your help.

 

[Sufiyan97]

Post you Data using below link

 

[jasonb75]

As long as the dates for each employee are in ascending order,

=LOOKUP(2,1/(Table2[Employee Name]=A47)/(Table2[Start Date]<=B47),Table2[True Cost Rate])

 

[fdfordham]

As long as the dates for each employee are in ascending order,

=LOOKUP(2,1/(Table2[Employee Name]=A47)/(Table2[Start Date]<=B47),Table2[True Cost Rate])

Works great! Thank you for the quick and succinct response.