"3 Way Lookup"

[MarkReddell]

I hope that there is "HELP" out there on this "3 Way Lookup" Problem! I thank you anyone in advance for any consideration on this issue!

I have on "work Log" sheet a employee work log where almost daily there are employee scheduling info.

1. date in Row,
2. Employee Name in Row.
3. Rate Column
on "Employee Wages" sheet. I have postings of:

1. date in Row,
2. Employee Name in Row,
3. Rate Column: which is the employee hourly wage.

I need to Be able to lookup the Rate of employee wage with the criteria on

1. date,
2. employee name
3. Rate: to find employee hourly wage & display on "work Log" sheet.

NOTE: I've try to fix this four a long time with very little success. I can get a formula to work on exact match on the date, however I need for the lookup of the employee rate of wage to be looked up on a prior or equal to the employee scheduled work date. So, four the date on or before the entry in the "Employee Wages" where entries R made only @ beginning date of employment & any minimum changes afterwards such as wages +/-, etc. Here is the formula that works only on last employee entry only:

CODE: {=INDEX('EMPLOYEE WAGES'!$A$5:$H$1004,MATCH(1,('WORK LOG'!A4>='EMPLOYEE WAGES'!$A$5:$A$1004)*('WORK LOG'!E4='EMPLOYEE WAGES'!$B$5:$B$1004),0),MATCH('WORK LOG'!$M$3,'EMPLOYEE WAGES'!$A$4:$H$4,0))} /CODE

I'm trying 2 build this 4 a friend that owns a restaurant & I'm stuck on this only!!! I need for lookup to work on or before on the date entries & an exact match on employee name. Help PLEASE!!!

[protonLeah]

Deleted comment due to post re-write

[MarkReddell]

Thank for your help. Hopefully I like learn how to do ALL of this!

[FDibbins]

Just to add into what Ben said regarding your thread being hard to read and follow...typing things like "I need 2 B able 2 lookup" when excel uses references such as B2, does not make it any easier. I would STRONGLY suggest you drop the short-hand and net-speak when explaining things here, and stick to full words

Also, you may have noted that Ben did not actually offer any help at all, just a suggestion that you clean up the text in your post