Adding history values

[Eddy S]

Hello everyone! My excel workbook is calculating jobs for each day. So far one man can get job 10 times but someone else maybe just 1 or not at all. I would like to know, how can I add job history to my vlookup formula? To make fare for everyone. Any ideas???

[Eddy S]

here is one of versions, need to test it. i hope it`s gonna work